SELECT wp_users.display_name as author, COUNT(wp_posts.ID) as posts
  FROM wp_posts, wp_users 
  WHERE wp_posts.post_author = wp_users.ID 
    AND month(wp_posts.post_date) = 11 
    AND YEAR(post_date) = 2007 
  GROUP BY post_author 
  ORDER BY total DESC;