SELECT concat(Name,'(', Substr(Occupation,1,1),')' ) from OCCUPATIONS ORDER BY Name ASC; SELECT CONCAT ('There are a total of',' ',COUNT(Occupation),' ', lOWER(Occupation),'s.') FROM OCCUPATIONS GROUP BY Occupation ORDER BY COUNT(Occupation);