programmers
[프로그래머스] 조건에 부합하는 중고거래 댓글 조회하기
대장형아
2023. 10. 22. 19:44
-- 코드를 입력하세요
SELECT U1.TITLE, U1.BOARD_ID, U2.REPLY_ID, U2.WRITER_ID, U2.CONTENTS, DATE_FORMAT(U2.CREATED_DATE,'%Y-%m-%d')
FROM USED_GOODS_BOARD U1 JOIN USED_GOODS_REPLY U2
ON U1.BOARD_ID = U2.BOARD_ID
WHERE U1.CREATED_DATE BETWEEN '2022-10-01' AND '2022-10-31'
ORDER BY U2.CREATED_DATE, U1.TITLE;