상품 별 오프라인 매출 구하기

문제 설명

예시

나의 풀이

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