title: How to get multiple counts with one SQL query?
body: <p>I am wondering how to write this query.</p>
  
  <p>I know this actual syntax is bogus, but it will help you understand what I am wanting.
  I need it in this format, because it is part of a much bigger query.</p>
  
  <pre><code>SELECT distributor_id, 
  COUNT(*) AS TOTAL, 
  COUNT(*) WHERE level = 'exec', 
  COUNT(*) WHERE level = 'personal'
  </code></pre>
  
  <p>I need this all returned in one query. </p>
  
  <p>Also, it need to be in one row, so the following won't work:</p>
  
  <pre><code>'SELECT distributor_id, COUNT(*)
  GROUP BY distributor_id'
  </code></pre>