[Programmers - MySQL] 상품 별 오프라인 매출 구하기

[초안]

SELECT  PRODUCT_CODE
       ,price * sales_amount as SALES
  FROM  product AS p
 RIGHT
  JOIN  offline_sale as s
    ON  p.product_id = s.product_id
 Order
    BY  SALES DESC, product_code ASC

 

[수정 후 정답] 

SELECT  product_code
       ,price * SUM(sales_amount) as SALES
  FROM  product AS p
 INNER
  JOIN  offline_sale as s
    ON  p.product_id = s.product_id
 GROUP
    BY  product_code
 Order
    BY  SALES DESC, product_code ASC