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

mysql 

-- 코드를 입력하세요
SELECT A.CATEGORY, SUM(B.SALES) AS TOTAL_SALES
FROM BOOK A
INNER JOIN BOOK_SALES B ON A.BOOK_ID = B.BOOK_ID
WHERE DATE_FORMAT(B.SALES_DATE, '%Y-%m') LIKE '2022-01'
GROUP BY CATEGORY
ORDER BY CATEGORY;