Q&A for Drupal developers and administrators
-- Average post score by calendar month select Convert(varchar(6), creationdate, 112) 'calendar month', avg(score) 'average post score' from posts group by Convert(varchar(6), creationdate, 112) order by Convert(varchar(6), creationdate, 112)