Q&A about the site for professors, theologians, and those interested in exegetical analysis of biblical texts
SELECT u.Id, u.DisplayName, COUNT(b.Id) AS BadgeCount FROM Users u JOIN Badges b ON u.Id = b.UserId WHERE u.Location LIKE '%Latvia%' GROUP BY u.Id, u.DisplayName HAVING COUNT(b.Id) > 100 ORDER BY COUNT(b.Id) DESC;