Question: Why am I getting this error and how can I fix it? 3 rows in set (0.03 sec) mysql> SELECT COUNT(*) AS RETURNED_AMOUNT, Orders.SKU AS

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


3 rows in set (0.03 sec) mysql> SELECT COUNT (*) AS RETURNED_AMOUNT, Orders.SKU AS PRODUCT_SKU, 

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>

Step by Step Solution

3.46 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!