title: mysql - embed count query within another query
body: <p>In postgres I am fairly sure you can do something like this</p>
  
  <pre><code>SELECT
    authors.stage_name, 
    count(select id from books where books.author_id  = authors.id) 
  FROM
    authors,
    books;
  </code></pre>
  
  <p>Essentially, in this example I would like to return a list of authors and how many books each has written.... in the same query.</p>
  
  <p>Is this possible? I suspect this approach is rather naive..</p>
  
  <p>Thanks :)</p>