Android : Ho can i find total price and revenue group by prodid...?

Prodid Price qty prod_name revenue date qty on hand

3 1790.00 1 Turtle 1790.00 07/10/2014 28.00 3 1790.00 2 Turtle 3580.00 07/10/2014 28.00 5 1300.00 1 Lee Cooper 1300.00 07/10/2014 30.00 5 1300.00 2 Lee Cooper 2600.00 07/10/2014 30.00 7 3200.00 3 Pepe Jeans 9600.00 07/10/2014 30.00 4 1500.00 1 John Player 1500.00 07/10/2014 35.00 6 3500.00 1 Wrangler 3500.00 07/10/2014 35.00 1 6000.00 1 Mufti XL Shirt 6000.00 07/10/2014 39.00 1 6000.00 2 Mufti XL Shirt 12000.00 07/10/2014 39.00 1 6000.00 3 Mufti XL Shirt 18000.00 07/10/2014 39.00 2 1688.00 1 Arrow Slim Fit 1688.00 07/10/2014 40.00