Write a script that creates and calls a stored procedure named test. this procedure should include two sql statements coded as a transaction to delete the row with a customer id of 8 from the customers table. to do this, you must first delete all addresses for that order from the addresses table.

if these statements execute successfully, commit the changes. otherwise, roll back the changes.