CREATE TABLE Record(Id varchar(20), LastName varchar(60), FirstName varchar(60), Age varchar(100), Gender varchar(20), Level varchar(50));
INSERT INTO Record(Id, LastName, FirstName, Age, Gender, Level) VALUES ('1', 'Santos', 'Mark Anthony', 17, 'Male', 'Freshman');
INSERT INTO Record VALUES('2', 'Nonat', 'Jayson', '15', 'Male', 'Sophomore');
INSERT INTO Record VALUES('3', 'Valencia', 'Nicole', '20', 'Female', 'Senior');
INSERT INTO Record VALUES('4', 'Campos', 'Jane', '19', 'Female', 'Junior');
INSERT INTO Record VALUES('5', 'Morales', 'Micah', '21', 'Female', 'Senior');
INSERT INTO Record VALUES('6', 'Atienza', 'Eldilbert', '17', 'Male', 'Sophomore');
INSERT INTO Record VALUES('7', 'Dela Cruz', 'Philip', '16', 'Male', 'Freshman');
INSERT INTO Record VALUES('8', 'Ramos', 'Loisa', '21', 'Female', 'Senior');
INSERT INTO Record VALUES('9', 'Galang', 'Orlean', '18', 'Male', 'Junior');
INSERT INTO Record VALUES('10', 'Detera', 'Chin', '16', 'Female', 'Freshman');

DECLARE @Id INT
DECLARE @Name NVARCHAR(100)
DECLARE @Age INT
DECLARE @Gender NVARCHAR(10)
DECLARE @Level NVARCHAR(50)
SET @Id = 1
WHILE @Id <= 10
   BEGIN
      SELECT
        @Name = FirstName + ' ' + LastName,
        @Age = Age,
        @Gender = Gender
      FROM Record
      WHERE Id = @Id
        IF @Age BETWEEN 14 AND 16
          SET @Level = 'Freshman'
        ELSE IF @Age BETWEEN 17 and 19
          SET @Level = 'Sophomore'
        ELSE IF @Age BETWEEN 20 and 22
          SET @Level = 'Junior'
        ELSE IF @Age BETWEEN 23 and 25
          SET @Level = 'Senior'
        ELSE
          SET @Level = 'Unknown'
      UPDATE Record
      SET Level = @Level
      WHERE Id = @Id
          PRINT 'ID: ' + CAST (@Id AS NVARCHAR(10)) + '| Name: ' + @Name + '| Age: ' + CAST(@Age AS NVARCHAR(10)) + '| Gender: ' + @Gender + '| Level: ' + @Level
          
      SET @Id = @Id + 1
    END