HACKERRANK 14일차 - 미완성

Occupations

SELECT Name
FROM OCCUPATIONS
GROUP BY Occupation
ORDER BY CASE 
            WHEN Occupation = Doctor THEN 1 
            WHEN Occupation = Professor THEN 2
            WHEN Occupation = Singer THEN 3
            ELSE Actor
        END AS

원하는 순서 지정하기
ORDER BY FIELD()

풀었던 문제 중에 가장 어려운 문제