[프로그래머스] 진료과별 총 예약 횟수 출력하기 (Oracle)

문제

https://school.programmers.co.kr/learn/courses/30/lessons/132202

프로그래머스

 

SELECT MCDP_CD AS "진료과코드", COUNT(1) AS "5월예약건수"
FROM APPOINTMENT
WHERE TO_CHAR(APNT_YMD, 'YYMM') LIKE '2205'
GROUP BY MCDP_CD
ORDER BY COUNT(1), MCDP_CD
;