[프로그래머스_SQL] 상품 별 오프라인 매출 구하기

📜문제

---

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

📜정답

---

    SELECT A.PRODUCT_CODE, SUM(A.PRICE * B.SALES_AMOUNT) AS SALES 
    FROM PRODUCT A INNER JOIN OFFLINE_SALE B
    ON A.PRODUCT_ID=B.PRODUCT_ID
    GROUP BY A.PRODUCT_CODE
    ORDER BY SALES DESC, A.PRODUCT_CODE ASC