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

SELECT mychoice.MCDP_CD as `진료과코드`, mychoice.c_apntno as `5월예약건수`
from (select MCDP_CD, count(APNT_NO) c_apntno
     from APPOINTMENT
     where APNT_YMD like '2022-05%'
     group by MCDP_CD
     ) as mychoice
group by MCDP_CD
order by mychoice.c_apntno asc, MCDP_CD asc