SELECT O.name ||'('||substr(o.occupation,1,1)||')'
from occupations as "O"
order by name,occupation;

select 
'There are a total of '|| count(*) ||' '||lower(occupation)||'s.'
from occupations
group by occupation
order by count(*), occupation ;