Closed ji-0630 closed 1 year ago
v=select MCDP_CD as "진료과 코드", count(*) as "5월예약건수"
from APPOINTMENT
where APNT_YMD like "2022-05-%"
group by MCDP_CD
order by 5월예약건수, MCDP_CD
SELECT MCDP_CD as "진료과 코드", count(*) as "5월예약건수"
from APPOINTMENT
where APNT_YMD like "2022-05-%"
group by MCDP_CD
order by count(*), MCDP_CD
문제 설명