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**
