SELECT DatePart(mm,CreationDate) Month, DatePart(yyyy,Cre...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

SELECT
DatePart(mm,CreationDate) Month,
DatePart(yyyy,CreationDate) Year,
Round(Avg(Cast(Score as float)),2) AvgScore,
Avg(ViewCount) AvgViews
FROM Posts
WHERE PostTypeId = 1
GROUP BY DatePart(mm,CreationDate), DatePart(yyyy,CreationDate)
ORDER BY DatePart(yyyy,CreationDate), DatePart(mm,CreationDate)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results