피벗 (1) 썸네일형 리스트형 pivot table - 행렬변환 SELECT COUNTRY , SUM(CASE WHEN activity='Adventure park' THEN num_of_places ELSE 0 END) as adventure_park , SUM(CASE WHEN activity='Golf' THEN num_of_places ELSE 0 END) as golf , SUM(CASE WHEN activity='River cruise' THEN num_of_places ELSE 0 END) as River_cruise , SUM(CASE WHEN activity='Kart racing' THEN num_of_places ELSE 0 END) as Kart_racing FROM ( WITH pivot_table AS ( SELECT 1 AS id, 'Fra.. 이전 1 다음