title: How to use group by to get multiple result set? grouping on multiple columns
body: <p>I have a table named as product which contains following data </p>
  
  <pre>
  pid            brand     color      
  
  1              sony      white
  2              casio     gray
  3              xoxo      blue
  4              samsung   white
  5              mvc       silver
  6              sony      gray
  7              xoxo      red
  8              samsung   silver
  9              mvc       white
  </pre>
  
  <p>I need to get total count of products belongs to each brand &amp; color. So i wrote 2 different queries.</p>
  
  <pre>
  Select count(pid) as total from products group by brand;
  Select count(pid) as total from products group by color;
  </pre>
  
  <p>This works fine. But since my product table data is huge, I think its better if I can achieve this by a single query. Is it possible?</p>