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

select a.TITLE, a.BOARD_ID, b.REPLY_ID, b.WRITER_ID, b.CONTENTS, DATE_FORMAT(b.CREATED_DATE,"%Y-%m-%d") as CREATED_DATE
from (select * from USED_GOODS_BOARD 
      where DATE_FORMAT(CREATED_DATE,"%Y-%m") = "2022-10") as a
inner join (select * from USED_GOODS_REPLY) as b
on a.BOARD_ID=b.BOARD_ID
order by  b.CREATED_DATE,a.TITLE;

 

잘 모르겠음.. 다른 솔루션 검색 필요

https://school.programmers.co.kr/learn/courses/30/lessons/164673

프로그래머스