title: sql Properly grouping my table
body: <p>I'm using MS Access in order to play around with tables through SQL. I want to properly group my table and this is an example of what I want to do. Say I have a table like this: </p>
  
  <pre><code>Cool?  |  Age
   Yes   |  15
   No    |  34
   No    |  12
   Yes   |  26 
   Yes   |  10
  </code></pre>
  
  <p>What I want is the resulting table to show how many ppl are cool or not grouped by age. For instance in this example it would be:</p>
  
  <pre><code> AGE  |   Count that are cool  | Count that is Not cool
  
   &lt;25  |          2             |           1
  
   &gt;=25 |          1             |           1
  </code></pre>
  
  <p>Thanks in advance!</p>