title: Using a subquery with NOT IN
body: <p>Find out how many books in the database are not part of the order.</p>
  
  <p>Query:</p>
  
  <pre><code>SELECT COUNT(title)
  FROM book INNER JOIN orders ON book.isbn = orders.bookID
  WHERE isbn NOT IN (bookID);
  </code></pre>