- 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