테이블 내에 여러개의 코드(불량)들이 개별 갯수를 가지고 구성되어 있을때
개별 합계를 구하는 놈!
SELECT
DEFECT_CODE_ID,
(SELECT DESCRIPTION FROM DEFECT_CODES WHERE ID = A.DEFECT_CODE_ID) AS DESCRIPTION,
SUM(DEFECT_QTY) AS QTY
FROM DEFECTS A
WHERE DEFECT_CODE_ID IN (SELECT DISTINCT( DEFECT_CODE_ID)
FROM DEFECTS)
GROUP BY DEFECT_CODE_ID
ORDER BY DEFECT_CODE_ID ASC
;
