[MySQL][Lv. 1] 조건에 부합하는 중고거래 댓글 조회하기 ✨

1. 풀이

SELECT TITLE, 
    A.BOARD_ID, 
    REPLY_ID, 
    B.WRITER_ID, 
    B.CONTENTS, 
    DATE_FORMAT(B.CREATED_DATE, "%Y-%m-%d") AS CREATED_DATE
FROM USED_GOODS_BOARD A
JOIN USED_GOODS_REPLY B
    ON A.BOARD_ID = B.BOARD_ID
WHERE DATE_FORMAT(A.CREATED_DATE, "%Y-%m") = "2022-10"
ORDER BY B.CREATED_DATE ASC, TITLE ASC;