Question scores over time

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT 
    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

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