select Users.DisplayName,,count(Posts.PostTypeid)...


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select Users.DisplayName,,count(Posts.PostTypeid) as "No. of answers",Votes.creationdate
from Users join Posts
on = Posts.OwnerUserId
join Votes
on = Votes.PostId
where Votes.creationdate between '2011-03-13' and '2011-03-19'
and Posts.PostTypeid = 2  and in ('29407','22656','616700','573261','157882','17034','115145','50079','34397','505088',
group by Users.DisplayName,,Votes.creationdate
order by count(Posts.PostTypeid) desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results