0

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT
  datepart(hour, creationdate) AS [Hour],
  sum(case when p.AnswerCount > 0 then 1 else 0 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]

fork query

edited apr 23 14

created apr 23 14 anonymous