문제 설명
예시
나의 풀이
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
intp
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