WITH NiceAnswerBadges AS ( SELECT * FROM Badges WHERE Nam...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

WITH NiceAnswerBadges AS (
  SELECT * FROM Badges WHERE Name = 'Nice Answer'
), 
UsersWithoutNiceAnswerBadges AS (
  SELECT * FROM Users
  WHERE Id NOT IN (SELECT UserId FROM NiceAnswerBadges)
)
SELECT TOP 10 * FROM UsersWithoutNiceAnswerBadges
WHERE UsersWithoutNiceAnswerBadges.Reputation > 10000
ORDER BY Reputation DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results