title: Count Distinct Values in column , Return Zero if not found On Where Clause
body: <p>This is my Table:</p>
  
  <p><img src="https://i.stack.imgur.com/yPdDZ.png" alt="This is my table "></p>
  
  <p>and I am running this query,</p>
  
  <pre><code>SELECT fruits,COUNT(*) as count FROM meva where owner = 'bill' GROUP BY fruits ORDER BY count 
  </code></pre>
  
  <p>and i am getting result as </p>
  
  <p><img src="https://i.stack.imgur.com/GOESJ.png" alt="enter image description here"></p>
  
  <p>Is it possible to get the other fruits items as 0 if not matched with owner like this,</p>
  
  <pre><code>Fruit   | count
  Apple   ,   2
  Mango   ,   0
  Banana  ,   0
  Strawberry ,0
  Appricot,   0
  Alfonso ,   0
  </code></pre>
  
  <p>A little modification in my query is most appreciated. 
  thanks</p>