Untitled

mail@pastecode.io avatar
unknown
plain_text
2 years ago
250 B
2
Indexable
Never
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