title: sql restricted count query
body: <p>I'm not certain how to structure a SQL query to return the number of rows where a column equals certain values.</p>
  
  <p>For instance,</p>
  
  <p>In table <code>myTable</code>, how can I return the count of all the rows where <code>myColumn = "xyz"</code> and where <code>myColumn = "abc"</code>? Is this possible with a single query?</p>
  
  <p>To clarify, say there are 10 rows where <code>myColumn = "xyx"</code> and 7 rows where <code>myColumn = "abc"</code>, the query would return something like:</p>
  
  <pre><code>firstCountResult: 10
  secondCountResult: 7
  </code></pre>