SELECT
	count(tv_inc.ope_sum) AS income_count,
	SUM(tv_inc.ope_sum) AS income_sum,

	count(tv_exp.ope_sum) AS expense_count,
	SUM(tv_exp.ope_sum) AS expense_sum
FROM
	transactions_view AS tv_inc,
	transactions_view AS tv_exp
WHERE
	tv_inc.tt_id = 1 AND
	tv_inc.tra_date BETWEEN 480463387 AND 912463388
AND
	tv_exp.tt_id = 2 AND
	tv_exp.tra_date BETWEEN 480463387 AND 912463388;