You are viewing a single comment's thread. Return to all comments →
I submitted the code below and the output is perfect but still it givers error.
SELECT CONCAT(Name, '(', SUBSTRING(Occupation, 1, 1), ')') AS Result FROM OCCUPATIONS
UNION ALL
SELECT CONCAT('There are a total of ', COUNT(Occupation), ' ', Occupation, 's.') AS Result FROM OCCUPATIONS GROUP BY Occupation ORDER BY Result;
Seems like cookies are disabled on this browser, please enable them to open this website
The PADS
You are viewing a single comment's thread. Return to all comments →
I submitted the code below and the output is perfect but still it givers error.
SELECT CONCAT(Name, '(', SUBSTRING(Occupation, 1, 1), ')') AS Result FROM OCCUPATIONS
UNION ALL
SELECT CONCAT('There are a total of ', COUNT(Occupation), ' ', Occupation, 's.') AS Result FROM OCCUPATIONS GROUP BY Occupation ORDER BY Result;