쿼리 공부(1)
WITH ScoreRanges AS ( SELECT COALESCE(cd, 'Total') AS cd, COUNT(*) AS count FROM your_table_name WHERE cd IN ('01', '02', '03') GROUP BY ROLLUP(cd) ) SELECT COALESCE(SBMS_YN, 'TOTAL') AS TYPE, NVL(SUM(CASE WHEN DICU_SCR BETWEEN 0 AND 20 THEN 1 END), 0) AS SCORE1, NVL(SUM(CASE WHEN DICU_SCR BETWEEN 21 AND 40 THEN 1 END), 0) AS SCORE2, NVL(SUM(CASE WHEN DICU_SCR BETWEEN 41 AND 60 THEN 1 END), 0) A..
2024. 2. 5.