Как в одной таблице по разным признакам в столбце вычесть сумма одних значений из других?

SELECT
    sum(
        if(bids.type IN (0) AND bids.status IN ('success'), bids.sum, 0)
    ) as `income`,
    sum(
        if(bids.type IN (1,2) AND bids.status IN ('realpay', 'success', 'verify'), bids.sum, 0)
    ) as `outcome`,
    sum(
        CASE
            WHEN bids.type IN (0) AND bids.status IN ('success')
                THEN bids.sum
            WHEN bids.type IN (1, 2) AND bids.status IN ('realpay', 'success', 'verify')
                THEN -bids.sum
            ELSE 0
        END
    ) as `balance`
FROM ...

select `income`, `outcome`, (`income` - `outcome`) `balance`
from (
  select
	sum(if(`type` = 0, `sum`, 0)) `income`,
	sum(if(`type` = 1, `sum`, 0)) `outcome`
  from tablename
) `data`;

with `data` as (
  select
	sum(if(`type` = 0, `sum`, 0)) `income`,
	sum(if(`type` = 1, `sum`, 0)) `outcome`
  from tablename
) select 
	`income`, `outcome`, (`income` - `outcome`) `balance` 
	from `data`;