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

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

SELECT MCDP_CD as '진료과코드', count(*) as '5월예약건수'
FROM APPOINTMENT
WHERE YEAR(APNT_YMD)=2022 and MONTH(APNT_YMD)=5
GROUP BY MCDP_CD
ORDER BY 5월예약건수, 진료과코드

1. WHERE DATE
2. GROUP BY
3. ORDER BY