132202.md

프로그래머스 132202

"진료과별 총 예약 횟수 출력하기"

🔗 https://school.programmers.co.kr/learn/courses/30/lessons/132202

SELECT MCDP_CD AS '진료과코드' , COUNT(MCDP_CD) AS '5월예약건수'
FROM APPOINTMENT
WHERE DATE(APNT_YMD) BETWEEN '2022-05-00' AND '2022-06-00'
GROUP BY MCDP_CD
ORDER BY 5월예약건수 ASC, MCDP_CD ASC