[HackerRank] Occupations

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

WITH occupation_partition AS (
    SELECT *
         , RANK() OVER (PARTITION BY Occupation ORDER BY Name) AS rnk
    FROM OCCUPATIONS
)

SELECT MIN(CASE WHEN Occupation = 'Doctor' THEN Name ELSE NULL END) AS Doctor
     , MIN(CASE WHEN Occupation = 'Professor' THEN Name ELSE NULL END) AS Professor
     , MIN(CASE WHEN Occupation = 'Singer' THEN Name ELSE NULL END) AS Singer
     , MIN(CASE WHEN Occupation = 'Actor' THEN Name ELSE NULL END) AS Actor
FROM occupation_partition
GROUP BY rnk