0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Average answer score/views by hour

SELECT
DatePart(hh,CreationDate) Hour,
Round(Avg(Cast(Score as float)),2) AvgScore,
Avg(ViewCount) AvgViews
FROM Posts
WHERE PostTypeId = 1
GROUP BY DatePart(hh,CreationDate)

fork query

created jun 24 11 Stuart Pegg