Q&A for people interested in the history and origins of science and mathematics
select u.Id, u.DisplayName, count(*) as post_count from Users as u join posts as p on p.OwnerUserId=u.Id group by u.Id, u.DisplayName