i have a table called university which have two fields id and name.

i tried this way.

SELECT CASE u.id

WHEN 2 THEN 'GOOD'

WHEN 3 THEN 'POOR'

WHEN 4 THEN 'EXCELLENT'

ELSE 'BAD'

END CASE

from university u;

it is not executing.can u suggest me where my query is wrong.....