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

문제

이미지 클릭시, 문제로 이동됩니닷 :)

풀이

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