title: Finding the first occurrence of an element in a SQL database
body: <p>I have a table with a column for customer names, a column for purchase amount, and a column for the date of the purchase. Is there an easy way I can find how much first time customers spent on each day?</p>
  
  <p>So I have </p>
  
  <pre><code>Name    |     Purchase Amount | Date
  Joe           10                9/1/2014
  Tom           27                9/1/2014
  Dave          36                9/1/2014
  Tom           7                 9/2/2014
  Diane         10                9/3/2014
  Larry         12                9/3/2014
  Dave          14                9/5/2014
  Jerry         16                9/6/2014
  </code></pre>
  
  <p>And I would like something like</p>
  
  <pre><code>Date     |     Total first Time Purchase
  9/1/2014       73
  9/3/2014       22
  9/6/2014       16
  </code></pre>
  
  <p>Can anyone help me out with this?</p>