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

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,
    P.Id AS PostId,
    P.Title AS PostTitle,
    P.Body AS PostBody
FROM 
    Users AS U
JOIN 
    Badges AS B ON U.Id = B.UserId
JOIN 
    Posts AS P ON U.Id = P.OwnerUserId
WHERE 
    B.Name = 'great answer' -- Filter for the specific badge
    AND U.Reputation > 20000 -- Filter for reputation score above 20000
ORDER BY 
    U.Id, P.Id;

Enter Parameters

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