Find questions which have 4 out of the required 5 votes to close.
Q&A for committed Christians, experts in Christianity and those interested in learning more
-- Find Questions Voted 4/5 To Close
-- Find questions which have 4 out of the required 5 votes to close.
SELECT TOP 10 Posts.Id AS [Post Link]
LEFT JOIN Votes
ON (PostId = Posts.Id)
WHERE Posts.PostTypeId = 1
--AND Votes.VoteTypeId = 6
--AND COUNT(Votes.Id) = 4
--GROUP BY Posts.Id;