0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

SELECT TOP 100
    u.Id,
    u.DisplayName,
    u.Location,
    u.Reputation,
    STRING_AGG(CAST(t.TagName AS VARCHAR(MAX)), ', ') AS Tags
FROM Users u
JOIN Posts p ON u.Id = p.OwnerUserId
JOIN PostTags pt ON p.Id = pt.PostId
JOIN Tags t ON pt.TagId = t.Id
WHERE u.Location LIKE '%Israel%'
  AND t.TagName IN ('node.js', 'python')
GROUP BY u.Id, u.DisplayName, u.Location, u.Reputation
ORDER BY u.Reputation DESC

fork query

edited oct 27

created sep 25 anonymous