Designed to consider whether "night" questions have more visibility than "day" questions
Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Japanese language
-- Questions by Time of Day and Day of Week -- Designed to consider whether "night" questions have more visibility than "day" questions select datename(weekday, Posts.CreationDate) Weekday, datepart(hour, Posts.CreationDate) Hour, count(Posts.Id) Questions from Posts where PostTypeid = 1 -- 1 = Question group by datename(weekday, Posts.CreationDate), datepart(hour, Posts.CreationDate) -- order by datepart(hour, Posts.CreationDate) order by count(posts.id) desc