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

mysql

-- 코드를 입력하세요
SELECT A.PRODUCT_CODE, **SUM**(A.PRICE * B.SALES_AMOUNT) AS SALES
FROM PRODUCT A
**JOIN** OFFLINE_SALE B 
ON A.PRODUCT_ID = B.PRODUCT_ID
**GROUP BY PRODUCT_CODE**
ORDER BY SALES DESC, PRODUCT_CODE

JOIN = INNER JOIN