Q1_m

 avatar
kuber
plain_text
4 years ago
237 B
8
Indexable
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; 
Editor is loading...