[SQL] 프로그래머스_카테고리 별 도서 판매량 집계하기_144855

JOIN, GROUP BY, YEAR, MONTH 이용하기

 

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

프로그래머스

 

 

-- 코드를 입력하세요
SELECT a.CATEGORY, SUM(b.SALES) AS TOTAL_SALES
FROM BOOK a
    JOIN BOOK_SALES b
    ON a.BOOK_ID = b.BOOK_ID
WHERE YEAR(b.SALES_DATE) = 2022 AND MONTH(b.SALES_DATE) = 1
GROUP BY a.CATEGORY
ORDER BY a.CATEGORY;