0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

SET DATEFIRST 1

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

fork query

edited jun 4 12 tskuzzy

created jun 24 11 Stuart Pegg