Occupations MySQL

 

문제

https://www.hackerrank.com/challenges/occupations/problem

풀이

• CASE문과 ROW_NUMBER()를 이용한다.

SELECT 
MIN(CASE WHEN OCCUPATION = 'Doctor' THEN NAME END), 
MIN(CASE WHEN OCCUPATION = 'Professor' THEN NAME END),
MIN(CASE WHEN OCCUPATION = 'Singer' THEN NAME END),
MIN(CASE WHEN OCCUPATION = 'Actor' THEN NAME END) 
FROM (SELECT OCCUPATION, NAME, ROW_NUMBER() OVER (PARTITION BY OCCUPATION ORDER BY NAME) B FROM OCCUPATIONS) 
A GROUP BY A.B

 

참조

https://jogrammer.tistory.com/248

[해커랭크(HackerRank)] Occupations (MySQL)