WITH temp as
(SELECT user_id,
       COUNT(id)
FROM stackoverflow.badges
WHERE creation_date::date BETWEEN '2008-11-15' AND '2008-12-15'
GROUP BY user_id
ORDER BY COUNT(id) DESC
LIMIT 10)
SELECT temp.user_id,
       temp.count,
       RANK() OVER (ORDER BY temp.count)
FROM temp   
ORDER BY temp.count DESC, temp.user_id