0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for speakers of other languages learning English

-- Enter Query Title
-- Enter Query Description

SELECT Age, COUNT(*) AS [Number of users], AVG(Reputation)AS [Average reputation], MAX(Reputation) AS [Highest reputation], (SELECT TOP 1 Id FROM Users WHERE Age = Main.Age AND Reputation = MAX(Main.Reputation) ORDER BY Id) AS [User Link] FROM Users AS Main GROUP BY Age ORDER BY Age;

fork query

created sep 24 10 Michael.Mrozek