Posts by Jon Skeet per day versus total badges he's earnt

1

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

select p.Id, p.CreationDate, (select count(b.id) 
   from badges b 
   where b.UserId = u.Id
   and b.Date < p.CreationDate
) as BadgesEarned 
from Posts P, Users u
where u.Id = 22656

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results