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

문제

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

프로그래머스

 

코드

MySQL

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