[프로그래머스, 144855] 별 도서 판매량 집계하기 (mysql)

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

프로그래머스

728x90

---

SELECT category, SUM(sales) as total_sales
FROM book
    INNER JOIN book_sales
    ON book.book_id = book_sales.book_id
WHERE sales_date LIKE '2022-01%'
GROUP BY category
ORDER BY category