You are viewing a single comment's thread. Return to all comments →
select name||'('||substr(occupation,0,1)||')' from OCCUPATIONS order by name asc ;
select 'There are a total of '||count()||' '||lower(occupation)||'s.' from occupations group by occupation order by count() asc, occupation asc;
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 name||'('||substr(occupation,0,1)||')' from OCCUPATIONS order by name asc ;
select 'There are a total of '||count()||' '||lower(occupation)||'s.' from occupations group by occupation order by count() asc, occupation asc;