Untitled

((SELECT CONCAT(Name, "(", SUBSTR(Occupation, 1, 1), ")") AS 'temp'
FROM OCCUPATIONS ORDER BY temp ASC) UNION ALL (SELECT CONCAT("There are a total of ", COUNT(Name), " ", LOWER(Occupation), "s.") AS 'temp' FROM OCCUPATIONS GROUP BY Occupation ORDER BY COUNT(Name))) ORDER BY temp;