0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT 
    datepart(yyyy, CreationDate) as 'year', avg(Score) as 'average'
FROM
    Posts
WHERE 
    PostTypeId = 2 
     and 
    CommunityOwnedDate is null
     and 
    ClosedDate is null
     and
    Score > 10  
GROUP BY
    datepart(yyyy, [CreationDate])

fork query

edited may 5 18

created may 5 18 anonymous