조건에 부합하는 중고거래 댓글 조회하기

[ji-0630]

문제 설명

[ji-0630]

나의 풀이

SELECT TITLE, b.BOARD_ID, REPLY_ID, r.WRITER_ID, r.CONTENTS, date_format(r.CREATED_DATE, "%Y-%m-%d")
from USED_GOODS_BOARD b right join USED_GOODS_REPLY r
on b.BOARD_ID = r.BOARD_ID
where date_format(b.CREATED_DATE, "%Y-%m") = "2022-10"
order by r.CREATED_DATE, TITLE