MSQL "Sum" problem 2 hours wasted to solve

Databases
1

i wasted 2 hours trying to solve this, still trying.
i will appreciate your help in this

SELECT 

sum((price-discount) * (quantity+quantity_store))) AS TOTAL_SALES

FROM 
orders_items


WHERE 
 
date BETWEEN '{$_GET['start_date']}' AND '{$_GET['end_date']}'

ORDER BY date DESC

I GET THIS ERROR

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS TOTAL_SALES FROM orders_items WHERE date BETWEEN ‘2010-02-01’ at line 3

I need to know the total amount of the sales in a specific time

2

Erm, you have one too many closing brackets. Change ))) to )) after quantity_store :slight_smile:

3

Thank you SJH, it was that simple but i did not notice it.