Complex db query

Hi I have column Header as below

item | price| quantity | buysell

Now I want query result as below

What is the sum of price*quantity based on Item based on buy
What is the sum of price*quantity based on Item based on sell
What is the sum of price*quantity based on item
What is the sum of pricequantity of buy - sum of pricequantity of sell based on item

is it possible? plz help

Level 75

You could probably as a first step goto the chapter on query Builder, and practice working out some aggregate functions.

Another good source to review aggregate functions is:

https://www.mysqltutorial.org/mysql-aggregate-functions.aspx

Please or to participate in this conversation.