You are viewing a single comment's thread. Return to all comments →
select concat(name,"(",left(Occupation,1),")") from occupations order by name;
select concat("There are a total of"," ",count()," ",lower(occupation),"s.") from occupations group by occupation order by count(),Occupation;
Seems like cookies are disabled on this browser, please enable them to open this website
The PADS
You are viewing a single comment's thread. Return to all comments →
select concat(name,"(",left(Occupation,1),")") from occupations order by name;
select concat("There are a total of"," ",count()," ",lower(occupation),"s.") from occupations group by occupation order by count(),Occupation;