Medium: Question 1

/*Medium part*/
SELECT concat(NAME, concat("(", concat(substring(OCCUPATION, 1, 1), ")"))) 
FROM OCCUPATIONS
ORDER BY NAME ASC;

SELECT concat("There are a total of ", count(OCCUPATION), " ", lower(OCCUPATION), "s.") 
FROM OCCUPATIONS
GROUP BY OCCUPATION
ORDER BY count(OCCUPATION) asc, OCCUPATION asc;