IF AND ELSE STATEMENT NOT WORKING IN PRINT RESULT

Viewed 60
SELECT 
    Id, FirstName, LastName, Age, Gender, Level 
FROM 
    [dbo].[Records]

IF (@myAge BETWEEN 14 AND 16)

    UPDATE [dbo].[Records] 
    SET Level = 'FRESHMAN' 
    FROM [dbo].[Records] 
    WHERE AGE BETWEEN 14 AND 16;

ELSE IF (@myAge  BETWEEN 17 AND 19)
    
    UPDATE [dbo].[Records] 
    SET Level = 'SOPHOMORE' 
    FROM [dbo].[Records] 
    WHERE AGE BETWEEN 17 AND 19;
    
ELSE IF (@myAge  BETWEEN 20 AND 22) 
    
    UPDATE [dbo].[Records] 
    SET Level = 'JUNIOR' 
    FROM [dbo].[Records] 
    WHERE AGE BETWEEN 20 AND 22;
    
ELSE IF @myAge  BETWEEN 22 AND 25 
    
    UPDATE [dbo].[Records] 
    SET Level = 'SENIOR' 
    FROM [dbo].[Records] 
    WHERE AGE BETWEEN 23 AND 25;
    
ELSE

    UPDATE [dbo].[Records] 
    SET Level = 'UNKNOWN' 
    FROM [dbo].[Records] 
    WHERE AGE IS NULL;

END

The result didn't change the level column, only freshman works. How to make the else-if statement fix the right code? Thank you so much

This is the result:

id: 1 Name: Santos Mark Antho Age:17 Gender:Male Level: **FRESHMAN**
id: 2 Name: Nonat JaysonI Age:15 Gender:Male Level: **FRESHMAN**
id: 3 Name: ValenciaNicoleu Age:20 Gender:Female Level: **FRESHMAN**
id: 4 Name: CamposJaneu Age:19 Gender:Female Level: **FRESHMAN**
id: 5 Name: MoralesMicahu Age:21 Gender:Female Level: **FRESHMAN**

enter image description here

0 Answers
Related