Users with at least 100 bronze badges

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select U.id as [User Link], count(B.id) as 'Bronze Badges'
from Users U
join Badges B
on U.id = B.userId
where B.class = 3
group by U.id
having count(B.id) >= 100
order by count(B.id) desc;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results