SELECT project_id, chart_id, SUM(amount) FROM ($sql) self GROUP BY project_id, chart_id HAVING SUM(amount) != 0