SELECT p.Id as Answer, COUNT(p.Id),Reputation FROM Posts ...

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

SELECT p.Id as Answer, COUNT(p.Id),Reputation
FROM Posts as p 
INNER JOIN Users as u
ON p.OwnerUserId = u.AccountId
WHERE 
PostTypeId = 2
AND p.CreationDate BETWEEN '07-31-2015' AND '12-31-2017'
GROUP BY p.Id, Reputation;

Enter Parameters

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