Question scores over time


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

    DATEPART(yyyy, CreationDate) AS [Year],
    Count(*) AS [Questions],
    AVG(CAST(Score AS float)) AS [Average Score]
FROM Posts
WHERE PostTypeId = 1
GROUP BY DatePart(yyyy, CreationDate)
ORDER BY DatePart(yyyy, CreationDate)

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results