title: Total SQL Server query
body: <p>I need a query that totals with sum others columns</p>
  
  <pre><code>User     sales    amount    date
  --------------------------------------
  danny    car      10.000    25/02/2016
  danny    moto      5.000    26/02/2016
  danny    car      10.000    25/03/2016
  danny    moto      5.000    26/03/2016
  danny    moto      5.000    26/03/2016
  danny    car      10.000    25/04/2016
  danny    moto      5.000    26/04/2016
  danny    car      10.000    25/05/2016
  danny    moto      5.000    26/05/2016
  </code></pre>
  
  <p>Result between dates filter by user and date should by:</p>
  
  <p>between 01/03/2016 and 31/03/2016</p>
  
  <pre><code>User   Total   moto    car     
  ------------------------------
  danny  15.000  2        1       
  </code></pre>
  
  <p>What query do I need?</p>