[프로그래머스][MySQL][Lv. 1] 조건에 부합하는 중고거래 댓글 조회하기

 

 

 

 

 

---

풀이)

 

-- 코드를 입력하세요
SELECT TITLE, USED_GOODS_REPLY.BOARD_ID, REPLY_ID, USED_GOODS_REPLY.WRITER_ID, USED_GOODS_REPLY.CONTENTS, DATE_FORMAT(USED_GOODS_REPLY.CREATED_DATE, '%Y-%m-%d') AS "CREATED_DATE" FROM USED_GOODS_BOARD INNER JOIN USED_GOODS_REPLY
ON USED_GOODS_BOARD.BOARD_ID = USED_GOODS_REPLY.BOARD_ID WHERE USED_GOODS_BOARD.CREATED_DATE BETWEEN '2022-10-01' AND '2022-10-31' ORDER BY USED_GOODS_REPLY.CREATED_DATE ASC, TITLE ASC;