SQL for Non-Programmers -- Homework Practice

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT TOP 100 Users.Id as [User Link], * 
FROM Users
WHERE Users.Id IN (SELECT UserId FROM Badges WHERE Name IN('Copy Editor', 'Electorate', 'Famous Question', 'Fanatic', 'Great Answer', 'Great Question', 'Legendary', 'Marshal', 'Populist', 'Publicist', 'Reversal', 'Stellar Question', 'Steward', 'Unsung Hero'))
ORDER BY Reputation ASC

Enter Parameters

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