WITH user_cnt AS (SELECT us.id,
                         COUNT(bd.id) AS post_cnt
                  FROM  stackoverflow.users us
                  JOIN stackoverflow.badges AS bd ON us.id = bd.user_id
                  WHERE bd.creation_date::DATE >= '2008-10-15' AND bd.creation_date::DATE <= '2008-11-15'
                  GROUP BY us.id
                  ORDER BY post_cnt DESC,
                           us.id
                  LIMIT 10)
SELECT *,
       DENSE_RANK() OVER(ORDER BY post_cnt DESC)
FROM user_cnt