[alquemist]

Nice! Should be easy to do max instead of count. Then top instead of max. Then top3 breaks the model.

[sergeykish]

Yes, should be max(count). I've lost you with top3.

    # select * from
      (select count from (select count(y.i), y.d from y group by y.d) _ limit 2) b,
      (select count(y.i), y.d from y group by y.d) a;
     count | count | d 
    -------+-------+---
         1 |     1 | 2
         2 |     1 | 2
         1 |     2 | 1
         2 |     2 | 1
    (4 rows)

[alquemist]

top - max value in the group

top3 - max 3 values in the group