SELECT COUNT(Votes.Id) AS UpVotes, COUNT(Votes.Id)/30 AS...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

-- 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##'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached