Untitled

SELECT concat(Name, '(', LEFT(Occupation, 1), ')') FROM Occupations
ORDER BY Name;
SELECT concat('There are a total of ', count(Occupation), ' ', lower(Occupation), 's.') FROM Occupations
GROUP BY Occupation
ORDER BY count(Occupation), Occupation asc;