Q&A for speakers of other languages learning English
select count(p.id) ,displayname from posts p inner join users u on p.owneruserid = u.id group by displayname