Q&A about the site for information security professionals
select top 15 OwnerUserId ,DisplayName ,count(a.id) count_posts from Posts a left join (select id, DisplayName from Users) b on a.OwnerUserId = b.Id group by OwnerUserId ,DisplayName order by count(a.id) desc