0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

SELECT TOP 50 Title, Body, Tags, Id, Score, ViewCount, FavoriteCount, AnswerCount, CreationDate, ClosedDate, AcceptedAnswerId
FROM Posts
WHERE Score > (SELECT AVG(Score) FROM Posts where CreationDate >  GETDATE() - 365) 
AND PostTypeId = 1 
AND AcceptedAnswerId IS NOT NULL AND CreationDate >  GETDATE() - 365
ORDER BY CAST( CreationDate AS DATE) ASC, Score DESC

fork query

edited sep 18

created sep 9 jon.doe45536