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

문제

풀이

SELECT mcdp_cd as '진료과코드', count(pt_no) as '5월예약건수'
from appointment
where apnt_ymd like '2022-05%'
group by mcdp_cd
order by count(mcdp_cd) asc, mcdp_cd asc;