[프로그래머스_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 CREATED_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 CREATED_DATE ASC, A.TITLE ASC

📜노트

---

SUBSTR(“문자열”, “시작위치”, “길이”)