select name, sal,
case when sal >= 4000 then 'Good'
when sal <= 2000 then 'Bad'
else 'Ok'
end as Status
from tablename
