프로그래머스 ORACLE 진료과별 총 예약 횟수 출력하기

 

정답

SELECT MCDP_CD AS "진료과코드", COUNT(MCDP_CD) AS "5월예약건수"
    FROM APPOINTMENT
WHERE TO_CHAR(APNT_YMD, 'YYMM') ='2205' --날짜변환
GROUP BY MCDP_CD
ORDER BY COUNT(MCDP_CD), MCDP_CD;