[SQL 고득점 Kit / GROUP BY ] Level 2 - 진료과별 총 예약 횟수 출력하기

문제

성공 코드

SELECT MCDP_CD AS "진료과코드", COUNT(APNT_NO) AS "5월예약건수"
FROM APPOINTMENT
WHERE YEAR(APNT_YMD) = 2022 AND MONTH(APNT_YMD) = 5
GROUP BY MCDP_CD
ORDER BY COUNT(APNT_NO), MCDP_CD;