From Violet Horse, 4 Months ago, written in Plain Text, viewed 64 times.
URL http://codebin.org/view/4c4fa92d Embed
Download Paste or View Raw
  1. with tb1 as (select b.user_id, count(b.id) as num
  2. from stackoverflow.badges b
  3. where b.creation_date between '15.11.2008' and '15.12.2008'
  4. group by b.user_id
  5. order by num desc
  6. limit 10)
  7. select *, dense_rank() over(order by num desc)
  8. from tb1

Reply to "Untitled"

Here you can reply to the paste above