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

SELECT 
    A.APNT_NO, 
    P.PT_NAME, 
    P.PT_NO, 
    D.MCDP_CD, 
    D.DR_NAME, 
    A.APNT_YMD 
FROM 
    PATIENT P
	JOIN APPOINTMENT A ON P.PT_NO = A.PT_NO
	JOIN DOCTOR D ON A.MDDR_ID = D.DR_ID
WHERE 
    D.MCDP_CD = 'CS' 
    AND A.APNT_CNCL_YN = 'N' 
    AND DATE_FORMAT(A.APNT_YMD, '%Y-%m-%d') = '2022-04-13'
ORDER BY 
    A.APNT_YMD ASC

• 정렬까지 꼼꼼히 잘 작성하자 ⭐️