[SQL문제풀기] 취소되지 않은 진료 예약 조회하기

문제

MYSQL

내가 작성한 정답

SELECT A.APNT_NO, P.PT_NAME, P.PT_NO, A.MCDP_CD, D.DR_NAME, A.APNT_YMD
FROM APPOINTMENT A
JOIN PATIENT P ON A.PT_NO=P.PT_NO 
JOIN DOCTOR D ON A.MDDR_ID = D.DR_ID
WHERE A.APNT_CNCL_YN = 'N' AND A.MCDP_CD = 'CS' AND DATE_FORMAT(A.APNT_YMD,'%y%m%d') = '220413'
ORDER BY APNT_YMD;

ORACLE

내가 작성한 정답

SELECT A.APNT_NO, P.PT_NAME, P.PT_NO, A.MCDP_CD, D.DR_NAME, A.APNT_YMD
FROM APPOINTMENT A
JOIN PATIENT P ON A.PT_NO=P.PT_NO 
JOIN DOCTOR D ON A.MDDR_ID = D.DR_ID
WHERE A.APNT_CNCL_YN = 'N' AND A.MCDP_CD = 'CS' AND TO_CHAR(A.APNT_YMD,'YYMMDD') = '220413'
ORDER BY APNT_YMD;