instruction: Find questions with close votes.
response: SELECT p.Id AS "post_link", COUNT(*) AS "occurrences" FROM Posts AS p INNER JOIN Votes AS v ON p.Id = v.PostId WHERE p.PostTypeId = 1 AND p.ClosedDate IS NULL AND v.VoteTypeId = 6 GROUP BY p.Id HAVING COUNT(*) >= 2 ORDER BY occurrences DESC