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

문제

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

프로그래머스

 

풀이

SELECT A.TITLE, A.BOARD_ID ,B.REPLY_ID, B.WRITER_ID, B.CONTENTS, TO_CHAR(B.CREATED_DATE, 'YYYY-MM-DD')
	FROM USED_GOODS_BOARD A JOIN USED_GOODS_REPLY B
	 ON A.BOARD_ID = B.BOARD_ID
   WHERE TO_CHAR(A.CREATED_DATE, 'yyyy-mm-dd') LIKE '2022-10%'
  ORDER BY B.CREATED_DATE, A.TITLE;