Re: Conditional return of aggregated data

> 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;

Am I missing something basic.  The above can be done using
GROUP BY and HAVING clause.