Quality of tag over a weekly cycle

0

Please login or register to vote for this query.

(click on this box to dismiss)

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.

Android Enthusiasts Meta

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

Enter Parameters

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