select userid as [User Link] , count(*) as [# questions] ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Overflow

Q&A about the site for professional and enthusiast programmers

select userid as [User Link]
     , count(*) as [# questions]
     , min(date) as [first awarded]
     , max(date) as [last awarded]
from badges
where name = 'Famous Question'
and class = 1
and tagbased = 0
group by userid

Enter Parameters

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