title: Count results with condition in the select part of the query
body: <p>I need the amount of words that start from all the characters of the alphabet, exist in my database</p>
  
  <p>I tried the following query:</p>
  
  <pre><code>SELECT 
      COUNT(id) FROM(SELECT id FROM words WHERE word LIKE 'A%') as A,
      COUNT(id) FROM(SELECT id FROM words WHERE word LIKE 'B%') AS B,
      ...
      COUNT(id) FROM(SELECT id FROM words WHERE word LIKE 'Z%') AS Z
  </code></pre>
  
  <p>When I run the query, it gives me this error:</p>
  
  <pre><code>Incorrect syntax near 'COUNT'.    
  Incorrect syntax near the keyword 'AS'.
  </code></pre>
  
  <p>The funny thing is that the query works fine if I only ask for the words that start with 'A'</p>
  
  <p>What am I doing wrong?</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>Just to clarify for future readers. The reason I want one check per letter of the alphabet, is because the alphabet can be different according to the language of the user and is going to be provided each time the query is generated</p>