title: SQL sum aggregate function gives wrong results
body: <p>My data is given below</p>
  
  <blockquote>
    <p>Right answer is Sum = 601,050.00</p>
  </blockquote>
  
  <p>But SQL sum aggregate function gives me wrong answer that is 5078150.00000</p>
  
  <p>15,000.00 <br>27,950.00 <br> 24,750.00 <br> 11,550.00 <br> 7,400.00 <br> 7,500.00  <br>14,650.00 <br> 12,500.00  <br>32,800.00  <br>35,700.00  <br>94,100.00  <br>10,100.00  <br>19,700.00 <br> 22,100.00  <br>35,450.00  <br>28,050.00  <br>50,150.00  <br>69,750.00 <br> 13,800.00 <br> 3,600.00  <br>18,600.00  <br>2,350.00  <br>7,200.00  <br>21,600.00 <br> 7,700.00  <br>4,500.00  <br>2,500.00</p>
  
  <pre><code>select  sum(SO_SalesOrder.OrderTotal),l.Name as [Store Name]
      From SO_SalesOrder inner join BASE_Location l on 
      SO_SalesOrder.LocationId = l.LocationId 
      inner join SO_SalesOrder_Line on SO_SalesOrder.SalesOrderId = 
      SO_SalesOrder_Line.SalesOrderId
      inner join BASE_Product on BASE_Product.ProdId = 
      SO_SalesOrder_Line.ProdId
      inner join BASE_Category on BASE_Category.CategoryId = 
      BASE_Product.CategoryId
      where SO_SalesOrder.OrderDate &gt;= '2018-02-01' and 
      SO_SalesOrder.OrderDate &lt;= '2018-02-28' and BASE_Category.Name = '1MHNZ'
      group by l.Name
  </code></pre>