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

 

https://school.programmers.co.kr/learn/courses/30/lessons/164673

프로그래머스

 

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