Untitled

SELECT CONCAT(name,'(',substring(Occupation,1,1),')') as Name 
FROM OCCUPATIONS
ORDER BY Name;
SELECT CONCAT ('There are a total of ', count(occupation),' ', lower(occupation),'s.') as TOTALS
FROM OCCUPATIONS
GROUP BY occupation
ORDER BY TOTALS