select year(CreationDate) as Year, month(CreationDate) ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics Meta

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

-- Enter Query Title
-- Enter Query Description


select
 year(CreationDate) as Year,
 month(CreationDate) as Month, 
 avg(Score)

from Posts
where PostTypeId = 1
group by year(CreationDate), month(CreationDate)
order by 1, 2

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results