We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
select (case when occupation = 'Doctor' then name +'(D)'
when occupation = 'Actor' then name +'(A)'
when occupation = 'Singer' then name +'(S)'
when occupation = 'Professor' then name +'(P)' end )
from occupations order by name;
select ('There are a total of '+convert(varchar(4),count())+' '+
lower(occupation)+'s.') from occupations group by occupation order by count() , occupation
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
The PADS
You are viewing a single comment's thread. Return to all comments →
select (case when occupation = 'Doctor' then name +'(D)' when occupation = 'Actor' then name +'(A)' when occupation = 'Singer' then name +'(S)' when occupation = 'Professor' then name +'(P)' end ) from occupations order by name;
select ('There are a total of '+convert(varchar(4),count())+' '+ lower(occupation)+'s.') from occupations group by occupation order by count() , occupation