title: SQL GROUP BY CLAUSE
body: <p>I have a table where I'm trying to pull some trend analysis from where the columns are Date(timestamp),RiskCategory(text) and Point(int). What I'm trying to return is for every date SUM the points and group by RiskCategory. I can get the latest via the following:</p>
  
  <pre><code>SELECT Date,RiskCategory,SUM(Point) AS Total 
  FROM risktrend WHERE DATE(Date) &gt;= (SELECT MAX(DATE(Date)) FROM risktrend) 
  GROUP BY RiskCategory;
  </code></pre>
  
  <p>but am struggling with the returning the same for ALL dates. Am using MySQL.</p>
  
  <p>I should further elaborate, that any date can have multiple entries, but the RiskCategory can only be Administrative,Availability, or Capacity. So, for every date I should see a SUM of points for the latter three. For example,</p>
  
  <pre><code>2010-10-06 Capacity 508
  2010-10-06 Administrative 113
  2010-10-06 Availability 243
  2010-10-07 Capacity 493
  2010-10-07 Administrative 257
  2010-10-07 Availability 324
  </code></pre>