Chapter 1. Retrieving Records select ename,sal, case when sal <= 2000 then 'UNDERPAID' when sal >= 4000 then 'OVERPAID' else 'OK' end as status from emp Page navigation ↑ SQL Adv – Session 1 ← SQL Programming (Advanced) – Welcome