"Easy" riddles

0

Please login or register to vote for this query.

(click on this box to dismiss)

Picks out some questions tagged as [riddle], with the following criteria: - Question text is less than 200 characters - At least 10 upvotes - Time between question being posted and answer being accepted is less than 4 hours - Answer text is less than 200 characters - Answer has at least - No more than 1 undeleted answer

Earth Science

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

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 Score >= 5
      AND LEN(Body) <= 200
      AND DATEDIFF(minute, Answer.CreationDate, Question.CreationDate) <= 240 -- 4 hours
  )

ORDER BY Score DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results