I have a table with a charge/credit column:
Item | PriceVal | CostVal | CHARGE_CODE
1 5 3 CH
2 8 5 CH
1 -5 -3 CR
3 7 1 CH
4 15 10 CH
1 5 3 CH
I've got the query I need to get the NET price and cost, but I'm also interested in the NET charges. Right now I have:
SELECT Item, SUM(PriceVal), SUM(CostVal) FROM Table GROUP BY Item
How do I get another column with the value COUNT(SUM(CHARGE_CODE=CH)-SUM(CHARGE_CODE=CR)).
I'm at a loss.