select Users.DisplayName,count(votes.VoteTypeid) as "No. ...

0

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(votes.VoteTypeid) as "No. of downvotes 03 - 09"
from Users join Posts
on Users.id = Posts.OwnerUserId
join Votes
on Posts.id = Votes.PostId
where Votes.creationdate between '2011-04-03' and '2011-04-09'
and Votes.VoteTypeid = 3
group by Users.DisplayName 
order by count(Votes.VoteTypeid)

Enter Parameters

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