Q&A for those using, extending or developing Emacs
DECLARE @BadgeName AS NVARCHAR(50) = ##BadgeName:string?Enlightened##; DECLARE @MyTop AS INT = ##MyTop:int?100##; SELECT TOP(@MyTop) Badges.UserId AS [User Link], Users.Reputation, @BadgeName AS BadgeName, COUNT(Badges.Id) AS NumberOfBadges FROM Badges INNER JOIN Users ON Users.Id=Badges.UserId WHERE Badges.Name = @BadgeName AND Users.Reputation > 10000 AND Users.Location = 'South Africa' GROUP BY Badges.UserId, Users.Reputation ORDER BY NumberOfBadges DESC