[SQL 문제 풀이] 진료과별 총 예약 횟수 출력하기

SELECT 
    MCDP_CD, COUNT(*)
FROM
    APPOINTMENT
WHERE
    APNT_YMD LIKE '%2022-05%'
GROUP BY MCDP_CD
ORDER BY COUNT(*) ASC , MCDP_CD ASC;