[Oracle] 취소되지 않은 진료 예약 조회하기

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

정답

SELECT A.APNT_NO,B.PT_NAME,A.PT_NO,A.MCDP_CD,C.DR_NAME,A.APNT_YMD
FROM APPOINTMENT A 
    INNER JOIN PATIENT B
        ON A.PT_NO = B.PT_NO
    INNER JOIN DOCTOR C
        ON A.MDDR_ID=C.DR_ID
WHERE A.MCDP_CD='CS'
    AND A.APNT_CNCL_YN='N'
    AND TO_CHAR(A.APNT_YMD,'YYYY-MM-DD')='2022-04-13'
ORDER BY A.APNT_YMD