CREATE TABLE Records (Id int PRIMARY KEY, LastName varchar(25), FirstName varchar(25), Age int, Gender varchar(25), Level varchar(25));

INSERT INTO Records (Id, LastName, FirstName, Age, Gender, Level) VALUES (1, 'Santos', 'Mark Anthony', 17, 'Male', 'Freshman');
INSERT INTO Records (Id, LastName, FirstName, Age, Gender, Level) VALUES (2, 'Nonat', 'Jayson', 15, 'Male', 'Sophomore');
INSERT INTO Records (Id, LastName, FirstName, Age, Gender, Level) VALUES (3, 'Valencia', 'Nicole', 20, 'Female', 'Senior');
INSERT INTO Records (Id, LastName, FirstName, Age, Gender, Level) VALUES (4, 'Campos', 'Jane', 19, 'Female', 'Junior');
INSERT INTO Records (Id, LastName, FirstName, Age, Gender, Level) VALUES (5, 'Morales', 'Micah', 21, 'Female', 'Senior');
INSERT INTO Records (Id, LastName, FirstName, Age, Gender, Level) VALUES (6, 'Atienza', 'Eldibert', 17, 'Male', 'Sophomore');
INSERT INTO Records (Id, LastName, FirstName, Age, Gender, Level) VALUES (7, 'Dela Cruz', 'Philip', 16, 'Male', 'Freshman');
INSERT INTO Records (Id, LastName, FirstName, Age, Gender, Level) VALUES (8, 'Ramos', 'Loisa', 21, 'Female', 'Senior');
INSERT INTO Records (Id, LastName, FirstName, Age, Gender, Level) VALUES (9, 'Galang', 'Orlean', 18, 'Male', 'Junior');
INSERT INTO Records (Id, LastName, FirstName, Age, Gender, Level) VALUES (10, 'Detera', 'Chin', 16, 'Female', 'Freshman');
 
BEGIN
DECLARE @loop int;
DECLARE @loopcount int;
DECLARE @r_Id int = 1;
DECLARE @r_LastName AS varchar(25);
DECLARE @r_FirstName AS varchar(25);
DECLARE @r_Age int = 0;
DECLARE @r_Gender AS varchar(25);
DECLARE @r_Level AS varchar(25);
SELECT @loop = COUNT(*) FROM Records;
SET @loopcount = 1;

WHILE @loopcount <= @loop
	begin
		SELECT @r_Id FROM Records WHERE Id = @loopcount;
		SELECT @r_LastName = LastName FROM Records WHERE Id = @loopcount;
		SELECT @r_FirstName = FirstName FROM Records WHERE Id = @loopcount;
		SELECT @r_Age = Age FROM Records WHERE Id = @loopcount;
		SELECT @r_Gender = Gender FROM Records WHERE Id = @loopcount;
		SELECT @r_Level = Level FROM Records WHERE Id = @loopcount;

SELECT CASE @r_Age
	WHEN 14 | 15 | 16 THEN 'Id:' + CAST (@r_id AS varchar(25)) +
				' | Name: ' + @r_FirstName + ' ' + @r_LastName +
				' | Age: ' + CAST (@r_Age AS varchar(25)) +
				' | Gender: ' + @r_Gender
	WHEN 17 | 18 | 19 THEN 'Id:' + CAST (@r_id AS varchar(25)) +
				' | Name: ' + @r_FirstName + ' ' + @r_LastName +
				' | Age: ' + CAST (@r_Age AS varchar(25)) +
				' | Gender: ' + @r_Gender
	WHEN 20 | 21 | 22 THEN 'Id:' + CAST (@r_id AS varchar(25)) +
				' | Name: ' + @r_FirstName + ' ' + @r_LastName +
				' | Age: ' + CAST (@r_Age AS varchar(25)) +
				' | Gender: ' + @r_Gender
	WHEN 23 | 24 | 25 THEN 'Id:' + CAST (@r_id AS varchar(25)) +
				' | Name: ' + @r_FirstName + ' ' + @r_LastName +
				' | Age: ' + CAST (@r_Age AS varchar(25)) +
				' | Gender: ' + @r_Gender
	END AS 'Records'
		
			IF @r_Age >= 14 AND @r_Age <= 16
				begin
				UPDATE Records SET Level = 'freshman';
				end
			ELSE IF  @r_Age >= 17 AND @r_Age <= 19
				begin
				UPDATE Records SET Level = 'sophomore';
				end
			ELSE IF  @r_Age >= 20 AND @r_Age <= 22
				begin
				UPDATE Records SET Level = 'junior';
				end
			ELSE IF  @r_Age >= 23 AND @r_Age <= 25
				begin
				UPDATE Records SET Level = 'senior';
				end
			ELSE
				begin
				UPDATE Records SET Level = 'unknown';
				end
			PRINT 'Id:' + CAST (@r_id AS varchar(25)) +
				' | Name: ' + @r_FirstName + ' ' + @r_LastName +
				' | Age: ' + CAST (@r_Age AS varchar(25)) +
				' | Gender: ' + @r_Gender +
				' | Level: ' + UPPER (@r_Level);
				
		SET @loopcount = @loopcount + 1;
	end
END