지문

SELECT dept, Q1, Q2 FROM ( SELECT dept, quarter_cd, amount FROM sales_q ) PIVOT ( SUM(amount) FOR quarter_cd IN ('Q1' AS Q1, 'Q2' AS Q2) );