Untitled
unknown
plain_text
3 years ago
250 B
5
Indexable
SELECT CONCAT(name,'(',substring(Occupation,1,1),')') as Name FROM OCCUPATIONS ORDER BY Name; SELECT CONCAT ('There are a total of ', count(occupation),' ', lower(occupation),'s.') as TOTALS FROM OCCUPATIONS GROUP BY occupation ORDER BY TOTALS
Editor is loading...