select top 30 count(*)'Questions Asked', OwnerUserId, (se...

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 top 30 count(*)'Questions Asked',
OwnerUserId,
(select DisplayName from Users where Id=OwnerUserId)'Display Name',
'http://stackoverflow.com/users/'+cast(OwnerUserId as varchar(100))'Link'

from Posts
where PostTypeId=1
group by OwnerUserId
order by count(*)desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results