SELECT CONCAT(NAME, '(', LEFT (OCCUPATION, 1), ')') as col1
FROM  OCCUPATIONS
ORDER BY  NAME;
  
SELECT CONCAT('There are a total of ', COUNT(OCCUPATION), ' ', lower(OCCUPATION), 's.') as col1
FROM OCCUPATIONS
GROUP BY OCCUPATION
ORDER BY COUNT(OCCUPATION), OCCUPATION;