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