For all canonical tags, what is the average question score and the average answer score?
Q&A for committed Christians, experts in Christianity and those interested in learning more
SELECT Tags.TagName AS [Tag Name] , AVG(Answers.Score) AS [Average Score] FROM Tags INNER JOIN PostTags ON PostTags.TagId=Tags.Id INNER JOIN Posts AS Questions ON Questions.Id=PostTags.PostId INNER JOIN Posts AS Answers ON Answers.ParentId=Questions.Id WHERE Answers.PostTypeId=2 GROUP BY Tags.Id, Tags.TagName ORDER BY 2 DESC, 1