title: Laravel - Sum values between two dates
body: <p>I need to sum values using Laravel db::table and get the result between two dates, example:</p>
  
  <p>Date: 05/30/2016 Sold: 1
   Date: 05/31/2016 Sold: 2</p>
  
  <p>So result should be Sold: 3</p>
  
  <p>This is a search result given by a filter by date, i have done something like this with no results:</p>
  
  <pre><code>DB::table('sales')
   -&gt;where('date',$date_from)
   -&gt;where('date',$date_to)
   -&gt;selectRaw('sum(price)')
   -&gt;selectRaw('id')
   -&gt;groupBy('id')
   -&gt;get(); 
  </code></pre>