[프로그래머스/ MySQL] 상품 별 오프라인 매출 구하기 (Lv.2)

✴️ 문제

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

 

✴️ 전체 코드(MySQL)

SELECT PRODUCT_CODE, SUM(PRICE * SALES_AMOUNT) AS SALES
FROM PRODUCT p JOIN OFFLINE_SALE s
    ON p.PRODUCT_ID = s.PRODUCT_ID
GROUP BY s.PRODUCT_ID
ORDER BY SALES DESC, PRODUCT_CODE