title: SQL find total count of each type in a column
body: <p>I'm learning SQL and am stumped on what should be a simple query. I have a table with the following pattern:</p>
  
  <pre><code>Id |  Type  
  ------------
  1  |  Red   
  2  |  Blue  
  3  |  Blue  
  4  |  Red   
  ..
  </code></pre>
  
  <p>I would like to write a query to return a table that counts the total number of instances of each type and returns a table with the following pattern, for example, if 'Blue' occurs in 12 rows, and 'Red' occurs in 16 rows in the table above, the result would be:</p>
  
  <pre><code>Blue | Red 
  -----------
   12  |  16 
  </code></pre>