0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

Select top 5 
  bgs.Name as Badge
  ,COUNT(usr.Id)
From Users usr
  Inner Join Badges bgs On bgs.UserId = usr.Id
Where Upper(usr.DisplayName) like 'ANDR%'
Group by bgs.Name
Order by COUNT(usr.Id) desc

fork query

edited nov 5

created nov 5 anonymous