[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를 비교