0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

select top 1000 
 Users.Id, Users.AccountId, Users.DisplayName, Users.UpVotes,
 count(Badges.Name) as Badges_Count
 
from Users
left join Badges
 on Users.Id = Badges.Id
 
where Users.LastAccessDate > '2020-01-01' and
Users.UpVotes > 0

group by Users.Id, Users.AccountId, Users.DisplayName, 
Users.UpVotes, Badges.Id, Badges.Name

order by Users.UpVotes desc;

fork query

edited oct 4 20

created oct 4 20 anonymous