SELECT CONCAT(Name,'(',LEFT(Occupation,1),')') FROM OCCUPATIONS ORDER BY Name; SELECT CONCAT("There are a total of ", COUNT(*),' ', LOWER(Occupation),'s.') from OCCUPATIONS GROUP BY Occupation ORDER BY COUNT(*);
