Q1_m

select concat(name,'(',left(occupation, 1),')') as name from occupations order by name;
select concat('There are a total of ', count(occupation),' ', lower(occupation), 's.') as total from occupations group by occupation order by total;