Designed to consider whether "night" questions have more visibility than "day" questions
Q&A for developers and researchers interested in open data
-- Questions by Time of Day and Day of Week
-- Designed to consider whether "night" questions have more visibility than "day" questions
FROM (SELECT Datepart(weekday, posts.creationdate) weekday,
CASE Round(Datepart(HOUR, posts.creationdate)/4, 1)
WHEN 0 THEN 'early morning'
WHEN 1 THEN 'morning'
WHEN 2 THEN 'late morning'
WHEN 3 THEN 'afternoon'
WHEN 4 THEN 'late afternoon'
WHEN 5 THEN 'evening'
END AS daytime
WHERE posttypeid = 1 -- 1 = Question
) AS X
GROUP BY weekday,
ORDER BY weekday,