Q&A for those who study, teach, research and apply economics and econometrics
SELECT t.TagName, AVG(p.Score) FROM Posts p JOIN PostTags pt ON pt.PostId = p.Id JOIN Tags t ON t.Id = pt.TagId GROUP BY t.tagName, t.Id