In MySQL Workbench in the Sakila database complete the questions and show that they work.

1. Create a trigger name before_film_delete, which will be called before any delete on film table for each row. The trigger will insert into film_archives table where:

~ filmnumber will be old film_id

~ customernumber will be old title

2. Write SQL statement to delete film_id =10, in film table.

3. Retrieve all records in table before_film_delete.To retrieve all records in the film_archives table.