select Votes.CreationDate,count(votes.VoteTypeid) as "Acc...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ukrainian Language Meta

Q&A for linguists, teachers and students of the Ukrainian language

select Votes.CreationDate,count(votes.VoteTypeid) as "Accepted",Users.DisplayName
from Users join Posts
on Users.id = Posts.OwnerUserId
join Votes
on Posts.id = Votes.PostId
where Votes.creationdate between '2011-03-11' and '2011-03-17'
and Votes.VoteTypeid = 1
group by Votes.CreationDate,Users.DisplayName 
order by Count(Votes.VoteTypeid) desc,Votes.CreationDate desc

Enter Parameters

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