Q&A for anime and manga fans
select t.TagName, count(t.TagName) as numberOfQuestion, sum(CAST(p.ViewCount AS BIGINT)) as numberOfView from PostTags pt join Posts p on pt.PostId = p.Id join Tags t on pt.TagId = t.Id group by t.TagName order by numberOfView