Q&A for power users of web applications
select users.displayname, count(posts.owneruserid) from users, posts where posts.owneruserid = users.id group by users.displayname;