dabrashin

SELECT *,
       DENSE_RANK() OVER(ORDER BY post_cnt DESC)
FROM (SELECT user_id,
             COUNT(name) AS post_cnt
      FROM stackoverflow.badges
      WHERE creation_date::DATE >= '2008-10-15' AND creation_date::DATE <= '2008-11-15'
      GROUP BY user_id
      ORDER BY post_cnt DESC,
               user_id
      LIMIT 10) AS w
ORDER BY post_cnt DESC,
               user_id