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

---

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

 

---

문제

---

풀이

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