Programmers/프로그래머스-취소되지 않은 진료 예약 조회하기-MySQL

문제

쿼리

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

결과

출처 & 깃허브

프로그래머스
github