Q&A for anime and manga fans
Select * FROM (select TOP 10000 t.TagName, year(p.CreationDate) as QuestionYear, p.Score, p.ViewCount, p.AnswerCount, p.CommentCount, p.FavoriteCount, (datediff(s, p.CreationDate, x.CreationDate)*1.0) as AnswerDelta, x.Score as AnswerScore FROM Posts p, Tags t, PostTags pt, Posts x WHERE p.AcceptedAnswerId = x.Id AND pt.PostId = p.Id AND pt.TagId = t.Id AND year(p.CreationDate) = '2020' and p.Score > 0 and t.Count > 100 and p.PostTypeId = 1 and p.CommunityOwnedDate is Null ORDER BY rand()) as res UNION ALL Select * FROM (select TOP 10000 t.TagName, year(p.CreationDate) as QuestionYear, p.Score, p.ViewCount, p.AnswerCount, p.CommentCount, p.FavoriteCount, (datediff(s, p.CreationDate, x.CreationDate)*1.0) as AnswerDelta, x.Score as AnswerScore FROM Posts p, Tags t, PostTags pt, Posts x WHERE p.AcceptedAnswerId = x.Id AND pt.PostId = p.Id AND pt.TagId = t.Id AND year(p.CreationDate) = '2019' and p.Score > 0 and t.Count > 100 and p.PostTypeId = 1 and p.CommunityOwnedDate is Null ORDER BY rand()) as res UNION ALL Select * FROM (select TOP 10000 t.TagName, year(p.CreationDate) as QuestionYear, p.Score, p.ViewCount, p.AnswerCount, p.CommentCount, p.FavoriteCount, (datediff(s, p.CreationDate, x.CreationDate)*1.0) as AnswerDelta, x.Score as AnswerScore FROM Posts p, Tags t, PostTags pt, Posts x WHERE p.AcceptedAnswerId = x.Id AND pt.PostId = p.Id AND pt.TagId = t.Id AND year(p.CreationDate) = '2018' and p.Score > 0 and t.Count > 100 and p.PostTypeId = 1 and p.CommunityOwnedDate is Null ORDER BY rand()) as res UNION ALL Select * FROM (select TOP 10000 t.TagName, year(p.CreationDate) as QuestionYear, p.Score, p.ViewCount, p.AnswerCount, p.CommentCount, p.FavoriteCount, (datediff(s, p.CreationDate, x.CreationDate)*1.0) as AnswerDelta, x.Score as AnswerScore FROM Posts p, Tags t, PostTags pt, Posts x WHERE p.AcceptedAnswerId = x.Id AND pt.PostId = p.Id AND pt.TagId = t.Id AND year(p.CreationDate) = '2017' and p.Score > 0 and t.Count > 100 and p.PostTypeId = 1 and p.CommunityOwnedDate is Null ORDER BY rand()) as res