For all canonical tags, what is the average question score and the average answer score?
Q&A for those who study, teach, research and apply economics and econometrics
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