0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for active researchers, academics and students of physics

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