title: SQL Query to create records of dates and amounts?
body: <p>I have a table that looks like that:</p>
  
  <pre><code>------------------------------------
  |  ID  | Amount | Date             |
  ------------------------------------
  |  1   | 50.00  | 10/02/2010       |
  |  2   | 20.00  | 10/02/2010       |
  |  3   | 30.00  | 12/02/2010       |
  |  4   | 70.00  | 12/02/2010       |
  |  5   | 40.00  | 12/02/2010       |
  ------------------------------------
  </code></pre>
  
  <p>The question now is, how can I create a query that will sum the amount and group them by date like that:</p>
  
  <pre><code>10/02/2010 70.00
  12/02/2010 140.00
  </code></pre>