SQL Queries

 use empdemographics;

select * from employeedemographics;

select *

from employeedemographics

where age>30

order by age;

select *,

case when age>30 then 'old'

else 'young'

end

from employeedemographics

where age is not null

order by age;

select *,

case when age>30 then 'old'

when age between 27 and 30 then 'young'

else 'baby'

end

from employeedemographics

where age is not null

order by age;

select *,

case when age=38 then 'stanley' 

when age>30 then 'old'

else'baby'

end 

from employeedemographics

where age is not null

order by age;