Q&A for gardeners and landscapers
SELECT u.Id AS [User Link], MAX(b.Name) AS 'One of the gold badges they have', COUNT(*) AS 'Number of gold badges', COUNT(*) AS 'Number of silver badges' FROM Users AS u INNER JOIN Badges AS b ON b.UserId = u.Id WHERE b.Class = 1 or b.class = 2 GROUP BY u.Id