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

문제

내가 틀린 정답

SELECT B.TITLE, B.BOARD_ID, R.REPLY_ID, R.WRITER_ID, R.CONTENTS
        , TO_CHAR(R.CREATED_DATE,'YYYY-MM-DD')
FROM USED_GOODS_BOARD B
LEFT JOIN USED_GOODS_REPLY R  ON R.BOARD_ID = B.BOARD_ID
WHERE TO_CHAR(B.CREATED_DATE,'YYYY-MM') = '2022-10'
ORDER BY R.CREATED_DATE ASC,B.TITLE ASC;

정답

SELECT B.TITLE, B.BOARD_ID, R.REPLY_ID, R.WRITER_ID, R.CONTENTS
        , TO_CHAR(R.CREATED_DATE,'YYYY-MM-DD')
FROM USED_GOODS_BOARD B
RIGHT JOIN USED_GOODS_REPLY R  ON R.BOARD_ID = B.BOARD_ID
WHERE TO_CHAR(B.CREATED_DATE,'YYYY-MM') = '2022-10'
ORDER BY R.CREATED_DATE ASC,B.TITLE ASC;