[HR] The Pads

https://www.hackerrank.com/challenges/the-pads/problem?isFullScreen=true

select concat(o1.name , '(', substr(o1.occupation, 1, 1) ,')') res1
from occupations o1
order by res1 asc;

select concat("There are a total of ", count(o2.name), " ", lower(o2.occupation), "s.") res2
from occupations o2
group by o2.occupation
order by res2 asc;