Question 5

0

Please login or register to vote for this query.

(click on this box to dismiss)

Game Development Meta

Q&A about the site for professional and independent game developers

WITH PostWithTagCounts AS (
    SELECT Top 10
        Posts.Id AS PostId,
        Posts.OwnerUserId AS UserId,
        Posts.Body AS PostBody,
        COUNT(PostTags.TagId) AS NumberOfTags,
        STRING_AGG(Tags.TagName, ', ') AS Tags
    FROM 
        Posts
    JOIN PostTags ON Posts.Id = PostTags.PostId
    JOIN Tags ON PostTags.TagId = Tags.Id
    WHERE 
        Posts.Tags IS NOT NULL
    GROUP BY 
        Posts.Id, Posts.OwnerUserId, Posts.Body
)
SELECT *
FROM PostWithTagCounts
WHERE NumberOfTags >= 5
ORDER BY NumberOfTags DESC;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results