title: SQL WHERE statement in SELECT?
body: <p>So I'm trying to output 2 columns that call on the same feature. Except 1 column I want the count of values less than 5 and another column I want count of values greater than 5. </p>
  
  <pre><code>SELECT COUNT (col_a) FROM table WHERE col_a &lt; 5
  </code></pre>
  
  <p>is how you get the first. </p>
  
  <p>But I'm wondering how to combine the 2 queries. Something like:</p>
  
  <pre><code>SELECT 
      COUNT(col_a WHERE col_a &lt; 5) AS col_1, 
      COUNT(col_a WHERE col_a &gt; 5) AS col_2 
  FROM table
  </code></pre>
  
  <p>Any ideas?</p>