SQL Count() question

sum(case when charge_code = CH then costval else 0 end)
- sum(case when charge_code = 'CR' then costval else 0 end)

sum(case when charge_code = CH then costval else 0 end)
- sum(case when charge_code = 'CR' then costval else 0 end)

select
    Item,
    sum(PriceVal),
    sum(CostVal),
    sum(PriceVal-CostVal)
from Table
group by Item

select
    Item,
    sum(PriceVal),
    sum(CostVal),
    sum(case when charge_code = 'CH' then 1 else 0 end) -
        sum(case when charge_code = 'CR' then -1 else 0 end)
from Table
group by Item

sum(case when charge_code = 'CH' then 1 else -1 end)

SELECT COUNT(IF(CHARGE_CODE=CH,1,NULL)) ...

SELECT SUM(IF(CHARGE_CODE=CH,PriceVal,0)) ...