Best time to answer

0

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

-- Best time to answer
-- Shows the best time in stackoverflow when you get fewest competetor for answering a question

SELECT
  DatePart(hour, CreationDate) as [DayTime],
  Count(Id) as [NumAnswers]
FROM
  Posts 
WHERE
  PostTypeId = 2
GROUP BY
  DatePart(hour, CreationDate)
ORDER BY
  DayTime

Enter Parameters

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