-- Create university Table.

CREATE TABLE dbo.university

(

[id] NUMERIC(10,0)

); NUMBER(10,0)

);

-- Insert sample data.

INSERT INTO university VALUES (1);

INSERT INTO university VALUES (2);

INSERT INTO university VALUES (3);

INSERT INTO university VALUES (4);

INSERT INTO university VALUES (5);

-- Select the data as a preview.

select [id] from university

-- Build the case statement with the following Rules:

-- ID of 2 = GOOD

-- ID of 3 = POOR

-- ID of 4 = EXCELLENT

-- all other ID values default to = BAD

SELECT

[id], -- Display the original value for [id].

CASE u.[id]

WHEN 2 THEN 'GOOD'

WHEN 3 THEN 'POOR'

WHEN 4 THEN 'EXCELLENT'

ELSE 'BAD'

END AS 'GRADE_REMARK' -- this is just a column label

FROM dbo.university AS u

-- Clean up the demonstration.

-- Drop the university table.

DROP TABLE dbo.university