0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for speakers of other languages learning English

-- Enter Query Title
-- Enter Query Description

SELECT COUNT(Votes.Id) AS UpVotes, COUNT(Votes.Id)/30 AS [UpVotesPerDay] FROM Votes, Posts WHERE Votes.VoteTypeId = 2 AND Votes.PostId = Posts.Id AND Posts.OwnerUserId = ##UserId## AND Votes.CreationDate > '##Date##'  AND Posts.CreationDate <= '##Date##'

fork query

created jun 21 10 anonymous