SELECT p.Id, COUNT(VoteTypeId) FROM Posts as p JOIN Votes...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Software Engineering

Q&A for expert programmers interested in professional discussions on software development

-- High answerer
SELECT p.Id, COUNT(VoteTypeId) FROM Posts as p JOIN Votes as v
ON p.Id = v.PostId
JOIN Users as u
ON p.Id = v.Id
WHERE u.Reputation >= 125
AND PostTypeId = 1
AND p.CreationDate BETWEEN '07-31-2015' AND '12-31-2017'
AND AnswerCount = 2
GROUP BY p.Id;

Enter Parameters

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