Q&A for scientists using computers to solve scientific problems
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;