Q&A about the site for expert genealogists and people interested in genealogy or family history
SELECT TOP 100 Users.Id, Users.Location, COUNT(Badges.Id) AS Badge_ID FROM Badges, Users Where Users.Id = Badges.UserId and Users.Location like '%Latvia%' GROUP BY Users.Id, Users.Location ORDER BY Badge_ID DESC