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
order by name asc;
select 'There are a total of' || ' ' || count(Occupation) || ' ' ||
lower(Occupation) || '' || 's'
from OCCUPATIONS
group by occupation
order by count(occupation),occupation asc;
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 order by name asc;
select 'There are a total of' || ' ' || count(Occupation) || ' ' || lower(Occupation) || '' || 's' from OCCUPATIONS group by occupation order by count(occupation),occupation asc;