title: Retrieving two COUNTs using a single SQL statement
body: <p>Assume Table1 has c1 column for which allowed values are either 1 or 0. </p>
  
  <p>How to retrieve number of 0s, 1s with a single query? Is it possible?</p>
  
  <p>sorry, STUPID way of questioning. </p>
  
  <p>I wanted the answer in a single row, not single column.</p>