The PADS(hackerrank)

오.. 해커링크 Medium 레벨 처음 푸는데 이렇게 겁 주기 있나요?
저의 답 쿼리.. 가 아니라 오답 쿼리요

SELECT CONCAT(Name, '(', SUBSTR(Occupation, 1, 1), ')') AS Name
FROM OCCUPATIONS
-- ORDER BY Name

UNION ALL

SELECT CONCAT('There are a total of ', count, ' ', Occupation, 's.') AS Name
FROM (
    SELECT Occupation
         , COUNT(Occupation) AS count
    FROM OCCUPATIONS
    GROUP BY Occupation
    -- ORDER BY count, Occupation
) AS T

-- 알게된 점
-- union을 할 때 각각의 쿼리를 먼저 정렬해놓으면 오류!

풀게되면 다시 돌아올게요.. 아디오스