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 Concat(Name,'(',Substring(occupation,1,1),')') as N
from occupations
order by name;
-> select 'There are a total of', + count(occupation), lower(concat(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 Concat(Name,'(',Substring(occupation,1,1),')') as N from occupations order by name;
-> select 'There are a total of', + count(occupation), lower(concat(occupation,'s.')) from occupations group by occupation order by count(occupation), occupation ;