instruction: Top 100 answers for a tag.
response: WITH TaggedQuestions AS (SELECT Posts.* FROM Posts JOIN PostTypes ON Posts.PostTypeId = PostTypes.Id JOIN PostTags ON PostTags.PostId = Posts.Id JOIN Tags ON PostTags.TagId = Tags.Id WHERE PostTypes.Name = 'Question' AND Tags.TagName = '##tag##'), TaggedAnswers AS (SELECT Posts.* FROM Posts JOIN TaggedQuestions ON Posts.ParentId = TaggedQuestions.Id JOIN PostTypes ON Posts.PostTypeId = PostTypes.Id WHERE PostTypes.Name = 'Answer') SELECT TaggedAnswers.Id AS "post_link", TaggedAnswers.Score AS "Score", Users.DisplayName AS "User" FROM TaggedAnswers JOIN Users ON TaggedAnswers.OwnerUserId = Users.Id ORDER BY Score DESC LIMIT 100