Q&A for folks dedicated to a lifestyle that can be maintained indefinitely without depleting available resources
-- Enter Query Title -- Enter Query Description with PostCounts as ( select Tags.Id as TagId, count(Posts.Id) as PostCount from Posts inner join PostTags on Posts.Id = PostTags.PostId inner join Tags on PostTags.TagId = Tags.Id group by Tags.Id ), Variants as ( select * from (select replace(TagName, 'ou', 'o') as vname, * from tags) as r where vname != tagname ) select Tags.TagName, Postcounts.PostCount from Tags inner join Variants on Tags.tagName = Variants.vname inner join PostCounts on Tags.Id = PostCounts.TagId ;