통계쿼리

ID	NAME	PRICE	MONTH
A001	과자	1000	01
A002	빵	2000	01
A002	빵	3000	02

SELECT ID,NAME,

SUM(CASE MONTH WHEN '01' THEN PRICE ELSE 0 END) AS 'M01',

SUM(CASE MONTH WHEN '02' THEN PRICE ELSE 0 END) AS 'M02'

FROM TABLENAME

WHERE 1=1

GROUP BY PROD_CD,NAME