SQL CODE PLEASE QUESTION:

Return only the total sales (price*move/qty) for each product that exceed $40,000. Again, the output should have the UPC of a product, the total sales of that product and have the calculated field renamed as totalSales.

THIS IS MY CODE: WHICH PRODUCES AN ERROR SAYING """"Not a condition in statement """

SELECT UPC, SUM((PRICE * MOVE / QTY)) AS totalSales FROM SALES WHERE totalSales > 40000.00 GROUP BY UPC;

NOTE: if I take out the "WHERE totalSales > 40000.00" the code runs fine