0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select Users.DisplayName,sum(votes.VoteTypeid) as "No. of Upvotes"
from Users join Posts
on Users.id = Posts.OwnerUserId
join Votes
on Posts.id = Votes.PostId
where Votes.creationdate between '2011-03-27' and '2011-04-02'
and Votes.VoteTypeid = 2
group by Users.DisplayName 
order by sum(Votes.VoteTypeid) desc

view current version

edited oct 4 18

created oct 4 18 jon.doe29493