title: How can I get multiple COUNTs from a single column with one query?
body: <p>In an application I've written, I have lots of queries that it seems should be one...  but I can't figure out how to do it.</p>
  
  <p>Here's a sample:</p>
  
  <pre><code>SELECT SUM(enrollment) AS SchoolEnrollment, COUNT(institutionID) AS NumberOfSchools
  FROM Schools
  WHERE LevelID IN (4,5,6,7,8,14,15,16,20)
  
  SELECT SUM(enrollment) AS SchoolEnrollment, COUNT(institutionID) AS NumberOfSchools
  FROM Schools
  WHERE LevelID IN (10,11)
  </code></pre>
  
  <p>Then I have four additional queries that are identical, only differing in the LevelID's that are INcluded in the last line.  I'm basically getting a sum of enrollments and number of schools, based on the grade levels they offer.</p>
  
  <p>Keep in mind that I not only need the results (I could simply UNION these queries), I need to know which number is which.</p>
  
  <p>Thanks for any advice.</p>
  
  <p>Russell Schutte</p>