Q&A for experienced flyers, pilots, and builders of drones and model aircraft
select top 1 Users.DisplayName, Users.UpVotes as Votes, Badges.Name as 'Badge', count(Badges.Name) as 'Number of Badges' from Users inner join Badges on Users.Id = Badges.UserId and Users.Location='South Africa' and Badges.Name = 'Enlightened' and year(Badges.Date) = '2016' group by Users.DisplayName, Users.UpVotes, Badges.Name order by(Users.UpVotes)