본문 바로가기
Beakjoon&프로그래머스/SQL

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

by 현장 2025. 3. 4.

-Code

SELECT
    TITLE,
    UGB.BOARD_ID,
    UGR.REPLY_ID,
    UGR.WRITER_ID,
    UGR.CONTENTS,
    DATE_FORMAT(UGR.CREATED_DATE, '%Y-%m-%d')
FROM
    USED_GOODS_BOARD AS UGB
    JOIN
    USED_GOODS_REPLY AS UGR
    ON
    UGB.BOARD_ID = UGR.BOARD_ID
WHERE
   UGB.CREATED_DATE LIKE '2022-10%'
ORDER BY
    UGR.CREATED_DATE,
    UGB.TITLE;