-
Notifications
You must be signed in to change notification settings - Fork 0
Closed
Description
💬 문제
https://school.programmers.co.kr/learn/courses/30/lessons/144855
💬 Idea
- BOOK_ID가 같은 것을 기준으로 BOOK과 BOOK_SALES 테이블을 조인한다.
- BS의 판매량 합계를 내서 TOTAL_SALES로 명명한다.
- CATEGORY로 그룹핑한다.
💬 풀이
SELECT B.CATEGORY, SUM(BS.SALES) AS TOTAL_SALES
FROM BOOK AS B JOIN BOOK_SALES AS BS
ON B.BOOK_ID = BS.BOOK_ID
WHERE BS.SALES_DATE BETWEEN '2022-01-01' AND '2022-01-31'
GROUP BY CATEGORY
ORDER BY CATEGORY