Stack Overflow questions with outstanding close votes

0

Please login or register to vote for this query.

(click on this box to dismiss)

A list of Stack Overflow questions with outstanding close votes, sorted by number of votes.

Stack Overflow

Q&A for programmers

-- Stack Overflow questions with outstanding close votes
-- A list of Stack Overflow questions with outstanding close votes, sorted by number of votes.


select
  Posts.Id as [Post Link],
  avg(Posts.Score) as [Score],
  count(*) as [Close Votes],
  min(Votes.CreationDate) as [First Vote],
  max(Votes.CreationDate) as [Last Vote]
from Posts
inner join Votes on Posts.Id=Votes.PostId
where Votes.VoteTypeId=6 and Posts.ClosedDate is NULL
group by Posts.Id
order by [Close Votes] desc

Enter Parameters

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