5. Write an UPDATE statement that modifies the product you added in exercise 4. This statement should change the discount percent column from 0% to 35%. 6. Write a DELETE statement that deletes the Keyboards category. When you execute this statement, it will produce an error since the category has related rows in the Products table. To fix that, precede the DELETE statement with another DELETE statement that deletes all products in this category. (Remember that to code two or more statements in a script, you must end each statement with a semicolon.) 7. Write an INSERT statement that adds this row to the Customers table: Use a column list for this statement. My Guitar Shop Exercises for Murach's MySQL (3 rd Edition) 8. Write an UPDATE statement that modifies the Customers table. Change the password column to "secret" for the customer with an email address of rick@raven.com. 9. Write an UPDATE statement that modifies the Customers table. Change the password column to "reset" for every customer in the table. If you get an error due to safe-update mode, you can add a LIMIT clause to update the first 100 rows of the table. (This should update all rows in the table.) 10. Open the script named create_my guitar shop.sql that's in the mgs_ex starts directory. Then, run this script. That should restore the data that's in the database