Untitled
unknown
plain_text
3 years ago
218 B
2
Indexable
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(*);