Timeline of posts closed as homework

0

Please login or register to vote for this query.

(click on this box to dismiss)

This query will show the posts closed as Off-Topic within the past 3 months which are tagged homework (though those two can be redefined).

Stack Overflow

Q&A for professional and enthusiast programmers

--This query will show the posts closed as Off-Topic within the past 3 months
--which are tagged homework (though those two can be redefined).


SELECT 
  Posts.ClosedDate,
  ROW_NUMBER() OVER(ORDER BY  Posts.ClosedDate) AS 'Post closures'
FROM 
    Posts
  JOIN 
    PostHistory 
  ON 
    Posts.Id=PostHistory.PostId
WHERE 
  Posts.ClosedDate IS NOT NULL
AND
  Posts.CreationDate > DATEADD(month, -##months?3##, GETDATE())
AND
  PostHistory.PostHistoryTypeId=10
AND
  PostHistory.Comment=102
AND
  Posts.Tags LIKE '%##tag?homework##%'

Enter Parameters

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