You are viewing a single comment's thread. Return to all comments →
select concat(Name,'(',Substring(Occupation,1,1),')') as Name
from occupations
Order by Name
select concat('There are total',' ',count(occupation),' ',lower(occupation),'s.') as total
group by occupation
order by total
Works like charm, but Please suggest is there is any other optimized way to write this.
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,'(',Substring(Occupation,1,1),')') as Name
from occupations
Order by Name
select concat('There are total',' ',count(occupation),' ',lower(occupation),'s.') as total
from occupations
group by occupation
order by total
Works like charm, but Please suggest is there is any other optimized way to write this.