instruction: Find questions ripe for the Revival and Necromancer badges. Searches for open, non-CW posts older than 60 days with no accepted answer and no answer scoring 2 or more. (Now updated so merged questions do not appear.)
response: SELECT p.Id AS "post_link", p.Score, p.CreationDate AS "asked_date", p.ViewCount FROM Posts AS p WHERE p.AcceptedAnswerId IS NULL AND p.PostTypeId = 1 AND p.CreationDate < CURRENT_TIMESTAMP() - 60 AND p.CommunityOwnedDate IS NULL AND p.ClosedDate IS NULL AND NOT EXISTS(SELECT * FROM Posts AS p2 WHERE p2.ParentId = p.Id AND p2.Score >= 2 AND p2.PostTypeId = 2) AND NOT EXISTS(SELECT * FROM PostHistory AS ph WHERE ph.PostId = p.Id AND ph.PostHistoryTypeId = 14) ORDER BY p.Score DESC LIMIT 1000