SELECT CONCAT(NAME, '(', LEFT(occupation, 1), ')') AS O
FROM OCCUPATIONS
ORDER BY NAME, O;
SELECT CONCAT('There are a total of ', COUNT(occupation), ' ', LOWER(occupation),'s. ')
FROM OCCUPATIONS
GROUP BY occupation
ORDER BY COUNT(occupation), occupation;