Untitled

 avatar
user_9914919852
mysql
2 years ago
214 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(*);