5

Please login or register to vote for this query.

(click on this box to dismiss)

Reputation of Stack Overflow members 16 and under, sorted by reputation in descending order. Seemingly anonymous users have not been included.

Q&A about the site for software quality control experts, automation engineers, and software testers

-- Members by Age and Reputation
-- StackOverflow members from youngest to oldest, by reputation over 1000.

DECLARE @Reputation int

SET @Reputation = (SELECT [Reputation] FROM Users WHERE Id = ##UserId##)

SELECT Id, DisplayName, Age, Reputation, CreationDate, LastAccessDate,
'http://stackoverflow.com/users/' + CAST(Id AS VARCHAR) AS Url
FROM Users b
WHERE (
b.Age <= 18
AND b.Reputation >= @Reputation
AND b.Id <> 1060350 
AND b.Id <> 569662 
AND b.Id <> 282601
AND b.Id <> 996493) OR b.Id = ##UserId##
ORDER BY b.Reputation DESC, b.Age;

fork query

edited apr 9 15 Qantas 94 Heavy

created jan 8 12 minitech