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 100 
 Users.Id, Users.AccountId, Users.DisplayName, Users.UpVotes,
 Badges.Name as 'Badges_Name', Badges.Date as 'Badges_Date'
 
from Users
left join Badges
 on Users.Id = Badges.Id
 
where Users.LastAccessDate > '2020-01-01' and
Users.UpVotes > 0
order by Users.UpVotes desc;

fork query

edited oct 4 20

created oct 4 20 anonymous