SELECT NAME || '(' || SUBSTR(Occupation, 1, 1) ||')'
FROM (SELECT * FROM OCCUPATIONS ORDER BY Occupation)
UNION
SELECT 'There are a total of '|| count(*) || ' ' || LOWER(Occupation) ||'s.'
FROM (SELECT * FROM OCCUPATIONS ORDER BY count(*))
GROUP BY Occupation;https://www.hackerrank.com/challenges/the-pads/problem?isFullScreen=true&h_r=next-challenge&h_v=zen
https://github.com/Dingadung