-- 코드를 입력하세요 SELECT MCDP_CD AS '진료과코드', COUNT(PT_NO) AS '5월예약건수' FROM APPOINTMENT WHERE APNT_YMD LIKE '2022-05%' GROUP BY MCDP_CD ORDER BY COUNT(PT_NO), MCDP_CD