How many upvotes did the post have on a day?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Programming Puzzles and Code Golf

Q&A for programming puzzle enthusiasts and code golfers

DECLARE @PostId int = ##PostId##

SELECT COUNT(*)
from (
select *
from Votes v
where v.PostId = @PostId
and v.VoteTypeId = 2
and v.CreationDate < CAST('2016-11-17' AS DATE)
) src;

Enter Parameters

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