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, 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
The error youre encountering is due to the use of the keyword MHERE in your SQL ... View full answer
Get step-by-step solutions from verified subject matter experts
