Answered/Unanswered Question Ratio over Time of Day

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

Q&A about the site for music historians, critics, and fans

SELECT
  datepart(hour, creationdate) AS [Hour],
  sum(case when p.AnswerCount = 0 then 0 else 1 end) * 1.0 / count(p.Id) / 1.0 as [Answered:Unanswered]
FROM
  Posts as p
WHERE
  p.PostTypeId = 1
  GROUP BY datepart(hour, creationdate)
ORDER BY [Hour]

Enter Parameters

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