SET DATEFIRST 1; SELECT top 10 DATENAME ( month , creati...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science Meta

Q&A for scientists using computers to solve scientific problems

SET DATEFIRST 1;
SELECT top 10

DATENAME ( month , creationdate )  ,round(avg(cast (score as float)),2)
from posts 
where posttypeid=1
group by DATENAME ( month , creationdate ) 
order by DATENAME ( month , creationdate )

Enter Parameters

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