instruction: Top results with specific tag.
response: SELECT * FROM (SELECT Posts.Id, TagName, Posts.Title, Posts.Body AS qBody, Posts.Score AS qScore, Answers.Body AS aBODY, Answers.Score AS aScore FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.Id INNER JOIN Posts ON Posts.Id = PostTags.PostId INNER JOIN Posts AS Answers ON Answers.Id = Posts.AcceptedAnswerId WHERE TagName = 'python' AND Posts.PostTypeId = 1 GROUP BY TagName, Posts.Id, Posts.Title, Posts.Body, Posts.Score, Answers.Body, Answers.Score) AS ss ORDER BY 5 DESC