SELECT concat(NAME, concat('(',SUBSTR(OCCUPATION, 1, 1),')')) FROM OCCUPATIONS order by name asc;
SELECT 'There are a total of', count(*), concat(lower(occupation),'s.') from occupations group by occupation order by count(occupation) asc, occupation asc;