You are viewing a single comment's thread. Return to all comments →
This worked for me:
select name||'(' || substr(Occupation,1,1) ||')' as Name from occupations order by Name asc;
select 'There are total' || ' ' || count(occupation) || ' ' || lower(occupation) || 's.' as total from occupations group by occupation order by total;
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 →
This worked for me:
select name||'(' || substr(Occupation,1,1) ||')' as Name from occupations order by Name asc;
select 'There are total' || ' ' || count(occupation) || ' ' || lower(occupation) || 's.' as total from occupations group by occupation order by total;