[프로그래머스] [MySQL] [Level 2] [JOIN] 상품 별 오프라인 매출 구하기

---

---

SELECT P.PRODUCT_CODE, (PRICE * AMOUNT) AS SALES
FROM PRODUCT P 
JOIN (
    SELECT PRODUCT_ID, SUM(SALES_AMOUNT) AS AMOUNT
    FROM OFFLINE_SALE
    GROUP BY PRODUCT_ID
) S
ON P.PRODUCT_ID = S.PRODUCT_ID
ORDER BY SALES DESC, PRODUCT_CODE;