select concat(name,"(",substr(occupation,1,1),")") from OCCUPATIONS
order by name;
select concat("There are a total of ",count(name)," ",lower(occupation),"s.")as total from OCCUPATIONS
group by(occupation)
order by count(occupation),occupation
order by name;
select concat("There are a total of ",count(name)," ",lower(occupation),"s.")as total from OCCUPATIONS
group by(occupation)
order by count(occupation),occupation
0 Comments:
Post a Comment