example-aggregate-functions-and-grouping-sum-using-multiple-columns- php mysql examples

Category id and Sum of product of received quantity and purchase price:

Category id	Sum of product of received quantity and purchase price
CA001	1725.00
CA002	965.00
CA003	900.00