select top 2000 owneruserid [User Link] , count(*) / conv...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Aviation

Q&A for aircraft pilots, mechanics, and enthusiasts

select top 2000 owneruserid [User Link]
     , count(*) / convert(decimal,reputation) [ratio]
from posts p 
inner join users u on u.id = p.owneruserid 
where owneruserid > 0
group by owneruserid, reputation
order by 2 desc

Enter Parameters

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