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) || ')' as result
from occupations;
select 'There are a total of '|| count(occupation) ||' '||
lower(occupation) || 's.' from occupations
group by occupation
order by count(occupation),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 name || '('|| substr(occupation,1,1) || ')' as result from occupations;
select 'There are a total of '|| count(occupation) ||' '|| lower(occupation) || 's.' from occupations group by occupation order by count(occupation),occupation;
/*