SELECT CONCAT(NAME, '(', LEFT(OCCUPATION, 1), ')') FROM OCCUPATIONS ORDER BY NAME;
SELECT CONCAT('There are a total of ', A.CNT, ' ', A.OCCUPATION, 's.') FROM
(
    SELECT LOWER(OCCUPATION) OCCUPATION, J.CNT FROM OCCUPATIONS O
    CROSS APPLY
    (
        SELECT COUNT(OCCUPATION) CNT FROM OCCUPATIONS WHERE LOWER(OCCUPATION) = O.OCCUPATION GROUP BY OCCUPATION
    ) J
) A GROUP BY CNT, OCCUPATION ORDER BY CNT;