0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists, academics, teachers, and students in the field of chemistry

Select Top 100
Users.Id, Reputation, DisplayName, Min(Badges.Class) as BestBadgeClass
From Users 
  Inner Join Badges On Badges.UserId = Users.Id
Group By Users.Id, Reputation, DisplayName
Having Min(Badges.Class) > 1
Order By Reputation Desc

fork query

edited oct 16 18

created oct 16 18 anonymous