Question 1

 avatar
user_6227789376
mysql
2 years ago
270 B
1
Indexable
Never
-- Medium
-- Question 1 (the Paid):

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(*), occupation;