title: Sql Query for number of available and total books
body: <blockquote>
    <p>I need a query which will  return list of book from book table</p>
    
    <p>but it will  show total number of books and books available too ..</p>
  </blockquote>
  
  <p>And for number of books it will count number of books with simular ISBN n amount count which will count number of books with simular ISBN with status available </p>
  
  <p>Table structure </p>
  
  <pre><code>Bookid booktitle author ISBN edition publisher price supplier volume language status
  
  status contains available,issued
  </code></pre>
  
  <p>I want result as  </p>
  
  <pre><code>BookTitle Author Publisher Location Total available
  </code></pre>
  
  <p>Please also explain the query because I need to implement it on many tables</p>
  
  <p>Queries i tried this far</p>
  
  <pre><code>select *,count(1) as Quantity from Book group  by Book.BookTitle
  </code></pre>
  
  <p>It successfully gives me book list with total quantity</p>
  
  <p>and </p>
  
  <pre><code>select *,count(1) as Quantity from Book where status='Available' group  by Book.BookTitle
  </code></pre>
  
  <p>It Successfully gives me list of books with how many are available.</p>
  
  <p>but i need combination of both total and available ..</p>