title: SQL counting with condition
body: <p>If I have a table called Buildings.</p>
  
  <pre><code> Room_No    Bldg Capacity 
      112     SCEN   23
      242     JBHT   25
      542     SCEN    4
      324     JBHT   24
  </code></pre>
  
  <p>What I want is to print out the Bldg name and the total number of rooms that have a capacity more than 20 in each building. So it is supposed to look like:</p>
  
  <pre><code> Bldg   Total
    SCEN    1
    JBHT    2
  </code></pre>
  
  <p>Am I going on the right track: </p>
  
  <pre><code> Select Bldg, Count(Capacity &gt; 20) as Total from Buildings Group By Total Desc
  </code></pre>