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) as [Answered:Unanswered]
FROM
  Posts as p
WHERE
  p.PostTypeId = 1 AND
  p.CreationDate >= Convert(datetime, '2010-04-01')
  GROUP BY datepart(hour, creationdate)
ORDER BY [Hour]

fork query

edited apr 23 14 jon.doe13597

created apr 23 14 anonymous