Untitled

 avatar
user_9914919852
mysql
3 years ago
214 B
5
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(*);
Editor is loading...