Untitled
user_1196610317
mysql
3 years ago
245 B
2
Indexable
SELECT CONCAT(NAME,'(',SUBSTR(OCCUPATION,1,1),')') AS N FROM OCCUPATIONS ORDER BY N; SELECT CONCAT('There are a total of ',COUNT(OCCUPATION),' ',LOWER(OCCUPATION),'s.') FROM OCCUPATIONS GROUP BY OCCUPATION ORDER BY COUNT(OCCUPATION), OCCUPATION;
Editor is loading...