In the RMA database, update a customer's records.

Write a SQL statement to select the current fields of status and step for the record in the RMA table with an OrderID value of $"5175".$

$1.$ What are the current status and step?

$$

$$

$$Write a SQL statement to update the status and step for the OrderID, $5175$ to status $=$ "Complete" and step $=$ "Credit Customer Account".

$1.$ What are the updated status and step values for this record?

$$

e$.$ Delete RMA records.

Write a SQL statement to delete all records with a reason of "Rejected".

$1.$ How many records were deleted? It says $0$ not sure if this because I am struggling with updating the status.

Right now I am getting an error and cannot seem to get it fixed and I don't understand why? mysql$>$ UPDATE RMA SET Status $=$ 'Complete', Step $=$ 'Credit Customer Account' WHERE OrderID $=5175$;

ERROR $1406(22001)$: Data too long for column 'Step' at row $12066$

mysql$>$ ALTER TABLE Orders MODIFY STEP Description VARCHAR$(200)$;

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 $\text{'}$De scription VARCHAR$(200)\text{'}$ at line $1$

mysql$>$