Q&A about the site for engineers, scientists, programmers, and computing professionals interested in quantum computing
SELECT TOP 10 STRING_AGG(Tags.TagName, ', ') AS Tags, Posts.Id AS PostId, Posts.OwnerUserId AS UserId, Posts.Body AS PostBody, COUNT(PostTags.TagId) AS NumberOfTags FROM Posts JOIN PostTags ON Posts.Id = PostTags.PostId JOIN Tags ON PostTags.TagId = Tags.Id GROUP BY Posts.Id, Posts.OwnerUserId, Posts.Body HAVING COUNT(PostTags.TagId) >= 5 ORDER BY NumberOfTags DESC;