SQL 알고리즘 코드카타 12일차(4) 26.01.10(토)

부제:

상품 별 오프라인 매출 구하기, 레벨 3

 

1. 문제 링크:https://school.programmers.co.kr/learn/courses/30/lessons/131533
2. 정답 코드:

SELECT
    p.product_code,
    sum(p.price*os.sales_amount) as sales        
from product as p
inner join offline_sale as os
    on p.product_id=os.product_id
group by p.product_code
order by sales desc, product_code asc

 
3. 오류 상황:

SELECT
    p.product_code,
    (p.price*os.sales_amount) as sales        
from product as p
inner join offline_sale as os
    on p.product_id=os.product_id
group by p.product_code
order by sales desc, product_code asc

=> 총 판매합 누락

4. 시도 방법: sum() 추가
5. 최종 문제 해결 방법: select문에  카테고리별 총 매출액을 계산해줄 sum() 추가