Answers to questions with at least 1000 views by low rep users at least 6 months after the question was asked. Includes improvements to only show a particular question once, and to show # of answers, average answer score, and time since the question was asked and the latest answer was posted.
Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation
-- Should we automatically protect old answered question questions with high views?
-- Answers to questions with at least 1000 views by low rep users at least 6 months after the question was asked
SELECT top 1000 q.Id as [Post Link], SUM(q.ViewCount)/COUNT(q.ViewCount) as Views, COUNT(a.Score) as '# Answers', AVG(a.Score) as [Avg Answer Score], datediff(m,MAX(q.CreationDate),MIN(a.CreationDate)) as 'Time between'
FROM posts q
INNER JOIN posts a ON a.parentid=q.id
INNER JOIN Users u ON a.OwnerUserID=u.Id
datediff(m, q.creationdate, a.creationdate) >= 6 and
u.reputation < 50 and
q.ViewCount >= 1000 and
GROUP BY q.id
ORDER BY COUNT(a.Score) DESC