SELECT *, RANK() OVER (ORDER BY cnt) as rank
FROM (
SELECT user_id, COUNT(id) cnt
FROM stackoverflow.badges
WHERE creation_date::date BETWEEN '2008-11-15' AND '2008-12-16'
GROUP BY user_id
) as ord

ORDER BY cnt DESC, user_id
LIMIT 10