[Programmers] MySQL 진료과별 총 예약건수

SELECT      MCDP_CD AS 진료과코드, COUNT(*) AS '5월예약건수'
FROM        APPOINTMENT
WHERE       APNT_YMD LIKE '%2022-05%'
GROUP BY    MCDP_CD
ORDER BY    COUNT(*), MCDP_CD