Allen's 데이터 맛집

문제 Pivot : https://en.wikipedia.org/wiki/Pivot_table 풀이 SELECT MAX(CASE WHEN occupation="Doctor" THEN name ELSE null END) AS doctor, MAX(CASE WHEN occupation="Professor" THEN name ELSE null END) AS professor, MAX(CASE WHEN occupation="Singer" THEN name ELSE null END) AS singer, MAX(CASE WHEN occupation="Actor" THEN name ELSE null END) AS actor FROM ( SELECT name, occupation, ROW_NUMBER() OVER(PA..