Picks out some questions tagged as [riddle], with the following criteria: - Question text is less than 200 characters - Time between question being posted and answer being accepted is less than 4 hours - Answer text is less than 200 characters - At least 10 upvotes - No more than 1 undeleted answer
プログラマーとプログラミングに熱心な人々のための質問と回答
SELECT Id as [Post Link], Score, Tags FROM Posts Question WHERE PostTypeId = 1 -- Question AND LEN(Body) <= 200 AND Score >= 10 AND AnswerCount = 1 AND EXISTS ( SELECT Id FROM Posts Answer WHERE PostTypeId = 2 -- Answer AND LEN(Body) <= 200 AND Score >= 5 AND DATEDIFF(minute, Answer.CreationDate, Question.CreationDate) <= 240 ) ORDER BY Score DESC