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] FROM Posts LEFT JOIN Votes ON (PostId = Posts.Id) --WHERE Posts.PostTypeId = 1 --AND Votes.VoteTypeId = 6 --AND COUNT(Votes.Id) = 4 --GROUP BY Posts.Id;