Please login or register to vote for this query.

(click on this box to dismiss)

Signal Processing Meta

Q&A about the site for practitioners of the art and science of signal, image and video processing

with table1 as 
 (select UserId, count(name) as BadgeCount from Badges
  group by UserId, Name)

select distinct Users.AccountId, Users.DisplayName, table1.*
 from Users
 left join table1 on Users.AccountId = table1.UserId
 order by BadgeCount desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results