SALES_DETAIL table contains sales_id, prod_type & Prod_price.

In this query I am trying to do aggregation from SALES_DETAIL table :

sum(prod_price) by sales_id & INSERTING into SALES_HEADER table as sales_amount.

Selecting cust_id...