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

😁나의 풀이

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 
    YEAR(board.CREATED_DATE) = 2022 AND MONTH(board.CREATED_DATE) = 10
ORDER BY
    CREATED_DATE asc,
    TITLE asc
;