abc

0

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 distinct UserId, count(name) as BadgeCount from Badges
  group by UserId, Name)


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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results