The average score of a question with a specified tag over one hour, for every hour in the week, in the range [0, 168). The idea was to test whether certain times of the week produce better questions than other times.
Q&A about the site for enthusiasts and power users of the Android operating system
SELECT --COUNT(*) AS cnt, AVG(CAST(Score AS float)) AS score, DH FROM ( SELECT TagName, Tags.Id, (DATEPART(weekday, CreationDate) - 1) * 24 + DATEPART(hour, CreationDate) AS DH, Score FROM Tags INNER JOIN PostTags ON TagId = Tags.Id INNER JOIN Posts ON PostId = Posts.Id WHERE Posts.ParentId IS NULL AND TagName = '##TagName##' ) AS sq GROUP BY DH ORDER BY DH