SELECT 
    CONCAT(NAME, '(', SUBSTR(OCCUPATION, 1, 1), ')') AS RESULT
FROM 
    OCCUPATIONS ORDER BY NAME;


SELECT  
    CONCAT('There are a total of ', COUNT(*), ' ', LOWER(OCCUPATION), 's.') AS RESULT
FROM 
    OCCUPATIONS 
GROUP BY 
    OCCUPATION 
ORDER BY 
    COUNT(OCCUPATION), OCCUPATION;