SELECT U.Id AS UserId, U.DisplayName AS Username, U.Reput...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Writing

Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing

SELECT 
    U.Id AS UserId,
    U.DisplayName AS Username,
    U.Reputation
FROM 
    Users AS U
JOIN 
    Badges AS B ON U.Id = B.UserId
WHERE 
    B.Class = 2-- Filter for gold badges
GROUP BY
    U.Id, U.DisplayName, U.Reputation
ORDER BY 
    U.Reputation DESC; -- Optionally, order by reputation score

Enter Parameters

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