Q&A for power users of web applications
select users.id as [Users Id], count(posts.id) from posts join users on owneruserid = users.id where posttypeid =2 group by users.id order by count(posts.id) desc