0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for information security professionals

SELECT
  STRING_AGG(t.TagName, ',') AS Tags,
  COUNT(t.TagName) AS NumberOfTags,
  p.Id AS PostId,
  p.OwnerUserId AS UserId,
  p.Body AS PostBody
FROM Tags AS t
INNER JOIN PostTags AS pt ON t.Id = pt.TagId
INNER JOIN Posts AS p ON pt.PostId = p.Id
GROUP BY p.Id, p.OwnerUserId, p.Body
HAVING COUNT(t.TagName) >= 5
ORDER BY COUNT(t.TagName) DESC;

fork query

edited jun 5 23

created jun 5 23 anonymous