Reversal with Open/Closed

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 100 a.Id AS [Post Link]
       , CASE WHEN q.ClosedDate IS NULL THEN 'Open' ELSE 'Closed' END
FROM Posts q
INNER JOIN Posts a
ON a.ParentId = q.Id
WHERE q.PostTypeId = 1
   AND q.Score <= -5
   AND a.Score >= 20

Enter Parameters

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