title: getting sum of count() in groupby
body: <p>Dont know if i am breaking comuntiy guidelines by posting a continuation question as new question. If so. I am sorry!!</p>
  
  <p>Now, using, </p>
  
  <pre><code>SELECT count(alertid) as cnt,date(alertdate) as alertDate 
  FROM alertmaster a,subscriptionmaster s 
  WHERE alertDate BETWEEN DATE_SUB(CURDATE(),INTERVAL 7 DAY) AND CURDATE() 
  GROUP BY date(alertDate),s.subId 
  ORDER BY a.alertDate DESC;
  </code></pre>
  
  <p>produces:<br>
  <strong>13, '2011-04-08'<br>
  13, '2011-04-08'<br>
  13, '2011-04-08'<br>
  14, '2011-04-07'<br>
  13, '2011-04-07'</strong>  </p>
  
  <p>Where I want is: </p>
  
  <p><strong>39, '2011-04-08'<br>
  27, '2011-04-07'</strong>  </p>
  
  <p>How to achieve this?</p>