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],
  1.0 / (sum(case when p.AnswerCount > 0 then 0 else 1 end)*10000 / count(p.Id) / 100.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