Players ranked by number of contest clears
WITH data as ( SELECT rank() OVER (ORDER BY count() DESC) as position, argMax(player, period) as player, count() as clears FROM pgcr.ventries WHERE referenceId = 1754635208 -- Equilibrium: Contest AND completed = 1 AND completionReason = 0 GROUP BY membershipId ORDER BY clears DESC ) SELECT * from data WHERE clears > 1 ORDER BY position ASC