select count(votes.VoteTypeid),Votes.creationdate from Us...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

select count(votes.VoteTypeid),Votes.creationdate
from Users join Posts
on Users.id = Posts.OwnerUserId
join Votes
on Posts.id = Votes.PostId
where Votes.creationdate between '2018-09-23' and '2018-09-29'
and Votes.VoteTypeid = 2 and Users.displayname = 'Gordon Linoff'
group by Votes.creationdate
order by Count(Votes.VoteTypeid) desc

Enter Parameters

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