카테고리 별 도서 판매량 집계하기

-- 코드를 입력하세요
SELECT CATEGORY, SUM(SALES) 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

 

구욷