Should we automatically protect old answered question questions with high views? (v3)

0

Please login or register to vote for this query.

(click on this box to dismiss)

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.

Reverse Engineering Meta

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
WHERE 
  datediff(m, q.creationdate, a.creationdate) >= 6 and 
  u.reputation < 50 and 
  q.ViewCount >= 1000 and
  a.posttypeid=2 and
  q.posttypeid=1
GROUP BY q.id
ORDER BY COUNT(a.Score) DESC

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results