[다시보기]GROUP BY - 저자 별 카테고리 별 매출액 집계하기

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

프로그래머스

 

SUM을 사용 하는걸 떠올리지 못해 오답 !

select B.AUTHOR_ID,	AUTHOR_NAME,	CATEGORY, (PRICE*SALES) as TOTAL_SALES
from BOOK  AS B
JOIN AUTHOR AS A on B.AUTHOR_ID=A.AUTHOR_ID
JOIN BOOK_SALES AS S on B.BOOK_ID=S.BOOK_ID
where DATE_FORMAT(sales_date,'%Y-%m')='2022-01'
group by B.AUTHOR_ID,CATEGORY
order by B.AUTHOR_ID,CATEGORY desc

 

 

 

-- 코드를 입력하세요
SELECT A.AUTHOR_ID,A.AUTHOR_NAME,B.CATEGORY, SUM(S.SALES * B.PRICE) as TOTAL_SALES
from BOOK as B
inner join AUTHOR as A on B. AUTHOR_ID = A.AUTHOR_ID
inner join BOOK_SALES as S on B.BOOK_ID = S.BOOK_ID
where DATE_FORMAT(SALES_DATE,'%Y-%m')='2022-01'
group by A.AUTHOR_ID,B.CATEGORY

order by AUTHOR_ID,CATEGORY desc