title: Select Count of Certain Rows as Column
body: <p>I have a table with a "status" column which accepts a <code>TINYINT</code>. For example:</p>
  
  <pre><code>name   | status
  -------+--------
  john   | 0
  joe    | 1
  johann | 0
  jan    | 1
  jane   | 0
  </code></pre>
  
  <p>How can I get a count of who is status 1 and who is status 0?</p>
  
  <pre><code>status1 | status0
  --------+--------
  2       | 3
  </code></pre>