Mysql Group By Date
===

I have Table with 2 Columns, Column1 with Date and Column2 stores Points which is nothing but Some random Number between 1 to 9.

Now I want to add the points grouped by date for last 5 days.
That is if I have 3 rows for day one, 1 rows for day two, 3 rows for day 3  and 2 rows for day 4 & 5  I should get the sum of points of these 11 rows grouped by date as 5 rows for five days.

**Input**

**Date**   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; **Points**

2012-07-01                                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;                                   5    
2012-07-01                                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;                                   6    
2012-07-01                                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;                                   2    

2012-07-02                                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;                                   5    

2012-07-03                                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;                                   8    
2012-07-03                                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;                                   7    
2012-07-03                                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;                                   1    

2012-07-04                                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;                                   3
<br/>2012-07-04                                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;                                   2


2012-07-05                                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;                                   3    
2012-07-05                                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;                                   9        

**Output**

**Date**   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; **Points**

2012-07-01                   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;              13 <br/>
2012-07-02                   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;               5 <br/>
2012-07-03                   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;              16 <br/>
2012-07-04                   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;                5 <br/>
2012-07-05                   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;              12 <br/>


Please suggest me a MySQL Query For the Above


  