Re: aggregation question

    -- select distinct causes multiple rows that tie for rank = 1

    -- to condense down to a single row. Outer query also strips 

    -- any rows from windows with less than 3 entries.

    select distinct count, total_ms, time, fk_e,
           fk_a, fk_b, fk_c
    from (        -- grab count and total_ms for each fk_g, grouped by        -- a,b,c, time, and e.  Use rank() window function        -- to rank each row in the window, ordered by total_ms/count        -- and use count(*) as window function to get total rows in        -- the window. 
        select sum(f.x) as count, sum(f.y) as total_ms,
               f.time as time,
               f.fk_a, f.fk_b, f.fk_c,
               f.fk_e, f.fk_f,
               rank() over (w_agg order by sum(f.x)/sum(f.y)) as rank,
               count(*) over (w_agg) as rows
        from fact_table f
        group by 3,4,5,6,7,8
        window w_agg as (partition by time,
                         fk_a, fk_b, fk_c,
                         fk_e)
    ) q
    where q.rank = 1 and q.rows >= 3