문제 설명

문제

답

SELECT APNT.APNT_NO,
       PT.PT_NAME,
       PT.PT_NO,
       APNT.MCDP_CD,
       DR.DR_NAME,
       APNT.APNT_YMD
FROM PATIENT PT,
     DOCTOR DR,
     APPOINTMENT APNT
WHERE PT.PT_NO = APNT.PT_NO 
AND DR.DR_ID = APNT.MDDR_ID
AND APNT.APNT_CNCL_YMD IS NULL	
AND APNT.MCDP_CD = 'CS'
AND APNT.APNT_YMD >= TO_DATE('2022-04-13', 'YYYY-MM-DD')
AND APNT.APNT_YMD < TO_DATE('2022-04-13', 'YYYY-MM-DD') + 1
ORDER BY APNT.APNT_YMD;