My initial idea was something along the lines of : select (select sum(statcount) from stats_residence) as aggstat,statcount,short_name_en from stats_residence where aggstat>some_number;
One option is to move the aggregate to the where-clause. If you also need the value in your select-list, you can just repeat the subselect there, usually the planner is smart enough to figure out that it can just re-use the result.
select short_name_en from stats_residence where (select sum(statcount) from stats_residence) >some_number;
--
If you can't see the forest for the trees, Cut the trees and you'll see there is no forest.
