[GROUP BY/LEVEL2] 진료과별 총 예약 횟수 출력하기 (MySQL/Oracle)

MySQL

SELECT MCDP_CD AS '진료과코드'
, COUNT(*) AS '월예약건수'
FROM APPOINTMENT
WHERE YEAR(APNT_YMD) = 2022
AND MONTH(APNT_YMD) = 5
GROUP BY MCDP_CD
ORDER BY 월예약건수, 진료과코드

 

---

 

Oracle

SELECT 
      MCDP_CD AS 진료과코드
    , COUNT(*) AS "5월예약건수"
FROM APPOINTMENT
WHERE TO_CHAR(APNT_YMD, 'YYYYMM') = '202205'
GROUP BY MCDP_CD
ORDER BY COUNT(*), MCDP_CD