Q&A for power users of web applications
select top 200 u.id as [User Link], total as [total] from users u inner join ( select owneruserid, count(*) as total from posts where posttypeid = 2 group by owneruserid ) a_tot on a_tot.owneruserid = u.id order by [total] desc