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

---

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

프로그래머스

---

문제

---

풀이

SELECT A.TITLE, A.BOARD_ID, B.REPLY_ID, B.WRITER_ID, B.CONTENTS, DATE_FORMAT(B.CREATED_DATE, '%Y-%m-%d')
FROM USED_GOODS_BOARD A LEFT JOIN USED_GOODS_REPLY B
ON A.BOARD_ID = B.BOARD_ID
WHERE A.CREATED_DATE BETWEEN '2022-10-01' AND '2022-10-31'
and REPLY_ID IS NOT NULL
ORDER BY B.CREATED_DATE ASC, A.TITLE ASC;