Q&A for professionals, academics, and students working within the systems development life cycle
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;