Why am I getting this error and how can I fix it? 3 rows in set (0.03

Why am I getting this error and how can I fix it?

 

Transcribed Image Text:

3 rows in set (0.03 sec) mysql> SELECT COUNT(*) AS RETURNED_AMOUNT, Orders.SKU AS PRODUCT_SKU, Orders.Description AS PRODUCT DESCRIPTION -> FROM Orders INNER JOIN RMA ON Orders.OrderID = RMA.OrderID -> INNER JOIN Customers ON Orders. CustomerID = Customers.CustomerID -> WHERE UPPER (State) IN ("WASHINGTON", "OREGON", "IDAHO", "MONTANA") -> WHERE UPPER (Status) = "COMPLETE" ->GROUP BY PRODUCT_SKU -> ORDER BY RETURNED_AMOUNT DESC -> LIMIT 3; ERROR 1064 (42000): 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 'WHERE UPPER(Status) = "COMP LETE" GROUP BY PRODUCT_SKU ORDER BY RETURNED_AMOUNT D' at line 5 mysql> 3 rows in set (0.03 sec) mysql> SELECT COUNT(*) AS RETURNED_AMOUNT, Orders.SKU AS PRODUCT_SKU, Orders.Description AS PRODUCT DESCRIPTION -> FROM Orders INNER JOIN RMA ON Orders.OrderID = RMA.OrderID -> INNER JOIN Customers ON Orders. CustomerID = Customers.CustomerID -> WHERE UPPER (State) IN ("WASHINGTON", "OREGON", "IDAHO", "MONTANA") -> WHERE UPPER (Status) = "COMPLETE" ->GROUP BY PRODUCT_SKU -> ORDER BY RETURNED_AMOUNT DESC -> LIMIT 3; ERROR 1064 (42000): 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 'WHERE UPPER(Status) = "COMP LETE" GROUP BY PRODUCT_SKU ORDER BY RETURNED_AMOUNT D' at line 5 mysql>

Answer rating: 100% (QA)

The error youre encountering is due to the use of the keyword MHERE in your SQL ... View the full answer