0

Please login or register to vote for this query.

(click on this box to dismiss)

What the title says

Q&A about the site for those using, extending or developing Emacs

DECLARE @tag VARCHAR(20);
SET @tag = 'javascript';

DECLARE @startyear DATETIME;
SET @startyear = '2010';

DECLARE @endyear DATETIME;
SET @endyear = '2018';

SELECT
  CAST(YEAR(CreationDate) AS VARCHAR(4)) + '-' + CAST(MONTH(CreationDate) AS VARCHAR(2)),
  -- gotta be a better way to do that
  ROUND(CAST(SUM(Score) AS FLOAT)/COUNT(Score), 2)
FROM Posts
WHERE
  CreationDate > @startyear AND
  CreationDate < @endyear --AND
  --CHARINDEX(@tag, Tags) > 0
GROUP BY
  YEAR(CreationDate),
  MONTH(CreationDate)
ORDER BY
  YEAR(CreationDate),
  MONTH(CreationDate);

view current version

edited dec 18 17

created dec 18 17 jon.doe27395