title: SQL - include empty fields
body: <p>I don't know if I worded my question correctly, but I'm new to SQL and I didn't really know how to word it. I am making a query about authors and the books they have written, and I want to include even the ones that have 0 books. How could I do this. This is my code, it is working correctly but it is leaving out the ones with 0 books:</p>
  
  <pre><code>SELECT surname as "Surname", forename as "Forename", COUNT(*) as "Books written"
  FROM book
       LEFT OUTER JOIN author ON author.authorid = book.authorid
  GROUP BY surname, forename
  ORDER BY surname;
  </code></pre>