Medium - Q1

select Name || '(' || left(Occupation,1) || ')' from OCCUPATIONS order by Name;
select 'There are a total of ' || count(Occupation) || ' ' || lower(Occupation) || 's.' from OCCUPATIONS group by Occupation order by count(Occupation), Occupation;