[SQL문제풀기] 조건에 부합하는 중고거래 댓글 조회하기

문제

MYSQL

내가 작성한 정답

SELECT B.TITLE, B.BOARD_ID, R.REPLY_ID, R.WRITER_ID, R.CONTENTS, 
        DATE_FORMAT(R.CREATED_DATE,'%Y-%m-%d') CREATED_DATE
FROM USED_GOODS_BOARD B
JOIN USED_GOODS_REPLY R ON B.BOARD_ID = R.BOARD_ID 
    AND DATE_FORMAT(B.CREATED_DATE,'%Y%m') = '202210' 
ORDER BY 6 ASC,1 ASC;

ORACLE

내가 작성한 정답

SELECT B.TITLE, B.BOARD_ID, R.REPLY_ID, R.WRITER_ID, R.CONTENTS, 
        TO_CHAR(R.CREATED_DATE,'YYYY-MM-DD') CREATED_DATE
FROM USED_GOODS_BOARD B
JOIN USED_GOODS_REPLY R ON B.BOARD_ID = R.BOARD_ID 
    AND TO_CHAR(B.CREATED_DATE,'YYMM') = '2210' 
ORDER BY 6 ASC,1 ASC;