title: Sql count include item with no value
body: <p>I have 2 different database from each library. Below is the sample data</p>
  
  <pre><code>Table Store
  Book Inventory
  AAA x
  AAA x
  AAA x
  AAA x
  AAB x
  AAB x
  AAC x
  
  Book Inventory
  AAA x
  AAA x
  AAA x
  AAB x
  AAD x
  AAE x
  
  
  SELECT Book, COUNT(book) from Store where book in ('AAA','AAB','AAC','AAD','AAE') group by Book
  </code></pre>
  
  <p>The result skipped those book with 0 value. How do i get return result even if the count is 0?</p>
  
  <pre><code>Expected result
  AAA 4
  AAB 2
  AAC 1
  AAD 0
  AAE 0
  
  AAA 3
  AAB 1
  AAC 0
  AAD 1
  AAE 1
  </code></pre>