[SQL문제풀기] 상품 별 오프라인 매출 구하기

문제

MYSQL, ORACLE

내가 작성한 정답

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