title: display count on same field based on different criteria from same table
body: <p>Say my table has only 2 fields: <code>Id</code> and <code>color</code>. </p>
  
  <pre><code>id  color
  ----------
  1   Green
  2   Red
  3   Yellow
  </code></pre>
  
  <p>I want the count to be displayed in a row not in a column. </p>
  
  <pre><code>  SELECT COUNT(color), color
      FROM MYTABLE
  GROUP BY color
  </code></pre>
  
  <p>This gives me:</p>
  
  <pre><code>count   color
  --------------
  10      Green
  20      Red
  15      Yellow
  </code></pre>
  
  <p>I need it to be displayed as:</p>
  
  <pre><code>Green  Red  Yellow
  -------------------
  10     20   15
  </code></pre>