728x90
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 (select * from USED_GOODS_BOARD
where DATE_FORMAT(CREATED_DATE,"%Y-%m") = "2022-10") as a
inner join (select * from USED_GOODS_REPLY) as b
on a.BOARD_ID=b.BOARD_ID
order by b.CREATED_DATE,a.TITLE;
잘 모르겠음.. 다른 솔루션 검색 필요
https://school.programmers.co.kr/learn/courses/30/lessons/164673
728x90
'• data analysis > PYTHON' 카테고리의 다른 글
[leetcode] 175. Combine Two Tables (0) | 2024.02.16 |
---|---|
[leetcode] 182. Duplicate Emails (0) | 2024.02.16 |
재구매가 일어난 상품과 회원 리스트 구하기 (0) | 2023.12.28 |
595. Big Countries (0) | 2023.12.28 |
1757. Recyclable and Low Fat Products (1) | 2023.12.28 |