[Programmers] 조건에 부합하는 중고거래 댓글 조회하기 (MySQL)

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

프로그래머스

---

🗒️ ERD

---

✏️ 제출 정답 코드

SELECT 
    board.TITLE as TITLE, 
    board.BOARD_ID as BOARD_ID, 
    reply.REPLY_ID as REPLY_ID, 
    reply.WRITER_ID as WRITER_ID, 
    reply.CONTENTS as CONTENTS, 
    date_format(reply.CREATED_DATE, '%Y-%m-%d') as CREATED_DATE
FROM USED_GOODS_BOARD as board 
    JOIN USED_GOODS_REPLY as reply
    ON board.BOARD_ID = reply.BOARD_ID
WHERE board.CREATED_DATE BETWEEN '2022-10-01' AND '2022-10-31'
ORDER BY reply.CREATED_DATE, board.TITLE;

---

📌 SQL문 정리

date_format() 사용법 정리

[SQL] date 타입에 대해 알아보기 (MySQL)