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

문제 링크

정답

-- PATIENT: PT_NO, PT_NAME, GEND_CD, AGE, TLNO
-- DOCTOR: DR_NAME, DR_ID, LCNS_NO, HIRE_YMD, MCDP_CD, TLNO
-- APPOINTMENT: APNT_YMD, APNT_NO, PT_NO, MCDP_CD, MDDR_ID, APNT_CNCL_YN, APNT_CNCL_YMD

SELECT A.APNT_NO, P.PT_NAME, A.PT_NO, A.MCDP_CD, D.DR_NAME, A.APNT_YMD
FROM APPOINTMENT AS A
JOIN PATIENT AS P
    ON A.PT_NO = P.PT_NO
JOIN DOCTOR AS D
    ON A.MDDR_ID = D.DR_ID
WHERE DATE(A.APNT_YMD) = '2022-04-13'
    AND A.MCDP_CD = 'CS'
    AND A.APNT_CNCL_YN != 'Y'
ORDER BY 6;

✅ Point

• DATE(A.APNT_YMD) = '2022-04-13'
  • Timestamp 형식인 APNT_YMD 와 DATE를 비교