[프로그래머스 SQL 고득점 Kit] GROUP BY: 진료과별 총 예약 횟수 출력하기

🤔 문제

✅ 정답

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