0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT * FROM (
  SELECT
    Posts.Id AS [Post Link],
    avg(Posts.Score) AS [Score],
    count(*) AS [Close Votes],
    max(Votes.CreationDate) AS [Last Vote],
    min(Votes.CreationDate) AS [First Vote]  
  FROM Posts
  JOIN Votes ON Posts.Id = Votes.PostId
  WHERE
    Votes.VoteTypeId = 6
    AND Posts.ClosedDate IS NULL
    AND Posts.Tags LIKE '%<##Tag##>%'  
  GROUP BY Posts.Id
) AS t 
WHERE [Close Votes] > 3
order by [Last Vote] desc

fork query

edited may 14 14

created may 14 14 Andrew Marshall