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