SET DATEFIRST 1; SELECT DATENAME ( week , creationdate )...

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 

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

Enter Parameters

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