title: select and return count of a particular value with results in SQL
body: <p>I want to select from a table and return the number of occurrences of a particular value in a column.  </p>
  
  <p>I also want the number of occurrences of that value to appear in the result set.</p>
  
  <p>For example</p>
  
  <p>With this Car table </p>
  
  <pre><code>type color 
  ===== ===
  bmw   blue
  lexus green
  Ford  blue
  KIA   yellow
  </code></pre>
  
  <p>I would like to build a query that will return the following results.</p>
  
  <pre><code>type  color   colorcount
  ===== ===     =======
  bmw    blue    2
  lexus  green   1
  Ford   blue    2
  KIA    yellow  1
  </code></pre>
  
  <p>I tried:</p>
  
  <pre><code>select type,color, count(color) from Car
  </code></pre>
  
  <p>but this obviously didn't work.  Does anyone know how this can be done?</p>