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,
    B.Name AS BadgeName
FROM 
    Users AS U
LEFT JOIN 
    Badges AS B ON U.Id = B.UserId
WHERE 
    U.Reputation >= 20000 -- Filter users with reputation score greater than or equal to 20,000
ORDER BY 
    U.Id;

Enter Parameters

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