Untitled

mail@pastecode.io avatar
unknown
plain_text
2 years ago
218 B
1
Indexable
Never
SELECT CONCAT(name, '(', LEFT(occupation, 1), ')') FROM occupations ORDER BY name;
SELECT CONCAT('There are a total of ', COUNT(*), ' ', LOWER(occupation), 's.') FROM occupations GROUP BY occupation ORDER BY COUNT(*);