I just found my answer
"SELECT post_title ,post_date, display_name ,wp_users.ID, wp_users.display_name as user_nicename, COUNT(*) as count
FROM wp_posts, wp_users, wp_term_relationships
WHERE wp_posts.post_type="post"
AND wp_posts.post_status="publish"
AND wp_posts.post_author = wp_users.ID
AND wp_posts.ID = wp_term_relationships.object_id
AND wp_term_relationships.term_taxonomy_id = '10'
GROUP BY post_author ORDER BY count DESC LIMIT 5 ;"