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 Name||'('|| substr(Occupation,1, 1) ||')' from OCCUPATIONS;
select 'There are a total of ' || count(Occupation) ||' ' || lower(Occupation) || 's.' from OCCUPATIONS
group by Occupation
order by count(Occupation),
case lower(Occupation)
when 'doctor' then 1
when 'singer' then 2
when 'actor' then 3
when 'professor' then 4
end;
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 Name||'('|| substr(Occupation,1, 1) ||')' from OCCUPATIONS;
select 'There are a total of ' || count(Occupation) ||' ' || lower(Occupation) || 's.' from OCCUPATIONS group by Occupation order by count(Occupation), case lower(Occupation) when 'doctor' then 1 when 'singer' then 2 when 'actor' then 3 when 'professor' then 4 end;