On Wed, 11 Dec 2019, Michael Lewis wrote:
> Put what you have in a subquery and group/aggregate again.
>
> select sample_count, count( site_nbr ) FROM (
> select site_nbr, count(distinct sampdate) AS sample_count from wrb_hg_cong
> group by site_nbr order by site_nbr
> ) sub
> group by sample_count;
Michael,
Well, darn! I totally speced using a subquery. Thank you very much for an
important lesson.
Best regards,
Rich