0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for information security professionals

with comment_count as (
select 
  UserId
  ,count(Id) count_comments
from 
  Comments
group by
  UserId
)
  
, post_count as (
select
  OwnerUserId
  ,count(a.id) count_posts
from 
  Posts a
group by
  OwnerUserId
)

select top 10
  coalesce(a.OwnerUserId, UserId) UserId
  ,count_posts + count_comments as total_count
from
  post_count a
full join
  comment_count b on a.OwnerUserId = b.UserId
order by
  count_posts + count_comments desc

fork query

edited oct 28

created oct 28 anonymous