SELECT ParentId,p.Id as Answer, Reputation,COUNT(p.Id) as...

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 ParentId,p.Id as Answer, Reputation,COUNT(p.Id) as num_answers
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 ParentId,p.Id, Reputation
ORDER BY num_answers DESC;

Enter Parameters

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