Q&A for anime and manga fans
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