SELECT count( `post_author` ) , display_name FROM `wp_posts` JOIN wp_users ON wp_posts.post_author = wp_users.id WHERE `post_status` = 'publish'