title: Display row where count(*) is zero using SQL
body: <p>I need write a query to show all the records which are present in where condition and if that column does not have any value it should return as 0.</p>
  
  <p>How can I write this query without using dual table?</p>
  
  <pre><code>SELECT city, count(city)
  FROM Customers
  where City IN ('ABCD','US' )
  group by city;
  </code></pre>
  
  <p><strong>Input</strong></p>
  
  <pre><code>City 
  
  US
  </code></pre>
  
  <p><strong>Output should be</strong> </p>
  
  <pre><code>ABCD  0
  
  US    1
  </code></pre>