[SQL] 취소되지 않은 진료 예약 조회하기(프로그래머스)

<문제 설명>

---

<문제>

---

<코드>

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