[프로그래머스 SQL 고득점 Kit] String, Date: 취소되지 않은 진료 예약 조회하기

문제

 

 

 

정답

SELECT B.APNT_NO, PT_NAME, C.PT_NO, B.MCDP_CD, A.DR_NAME, B.APNT_YMD
FROM DOCTOR AS A JOIN APPOINTMENT AS B ON A.DR_ID = B.MDDR_ID JOIN PATIENT AS C ON B.PT_NO = C.PT_NO
WHERE APNT_YMD LIKE '2022-04-13%' AND APNT_CNCL_YN = 'N' AND B.MCDP_CD = 'CS'
ORDER BY APNT_YMD