title: Count first letter of titles and print A to Z
body: <p>I am trying to count the first letter of the titles so that I can have a list of A to Z.
  The problem is I can`t display the letters that have 0 count.</p>
  
  <pre><code>SELECT SUBSTRING(UCASE(title), 1, 1) as letter, count(id) as total 
  FROM `a-z` 
  GROUP BY SUBSTRING(title, 1, 1)
  </code></pre>
  
  <p>this query gives me this result:</p>
  
  <p><a href="https://i.stack.imgur.com/vSQOi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vSQOi.png" alt="enter image description here"></a></p>
  
  <p>How can I print all the letters from A to Z and display 0 for the count if there is no title starting with that letter such as?</p>
  
  <pre><code>A 1
  B 0
  C 0
  ...
  Z 0
  </code></pre>