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, '(', LEFT(Occupation,1), ')' ) AS ONAME
FROM occupations
ORDER BY Name ASC;
SELECT
CONCAT("There are a total of ",COUNT(Occupation),' ',LOWER(Occupation),'s.') AS ODETAILS
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 CONCAT ( Name, '(', LEFT(Occupation,1), ')' ) AS ONAME FROM occupations ORDER BY Name ASC;
SELECT CONCAT("There are a total of ",COUNT(Occupation),' ',LOWER(Occupation),'s.') AS ODETAILS FROM occupations GROUP BY Occupation ORDER BY COUNT(Occupation), Occupation ASC;