0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for SharePoint enthusiasts

SELECT
    STRING_AGG(T.TagName, ',') AS Tags,
    COUNT(PT.TagId) AS NumberOfTags,
    P.Id AS PostId,
    P.OwnerUserId AS UserId,
    P.Body AS PostBody
FROM Posts P
JOIN PostTags PT ON P.Id = PT.PostId
JOIN Tags T ON PT.TagId = T.Id
GROUP BY P.Id, P.OwnerUserId, P.Body
HAVING COUNT(PT.TagId) >= 5;

fork query

created nov 2 jon.doe46164