0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

-- Diese Abfrage sucht nach Nutzern auf Stack Overflow, die relevante Tags in ihren Beiträgen verwendet haben.
SELECT TOP 100
    u.Id AS [User Link],
    u.DisplayName,
    u.Reputation,
    COUNT(p.Id) AS [Post Count]
FROM
    Posts p
INNER JOIN
    PostTags pt ON p.Id = pt.PostId
INNER JOIN
    Tags t ON pt.TagId = t.Id
INNER JOIN
    Users u ON p.OwnerUserId = u.Id
WHERE
    t.TagName IN ('javascript', 'vue.js', 'angular', 'reactjs', 'html5', 'css', 'java', 'nosql', 'sql', 'microservices', 'api', 'cloud', 'openshift', 'aws', 'scrum', 'kanban', 'tdd', 'ci-cd', 'selenium', 'cucumber')
GROUP BY
    u.Id, u.DisplayName, u.Reputation
ORDER BY
    [Post Count] DESC, u.Reputation DESC

fork query

created jul 17 anonymous