In Sakila Database sample do the following:

7. Create table film_archives with 4 attributes: - id which is auto increment - filmnumber integer, primary key - filmname with 50 characters and must be not null - delete_at which is date and time when delete takes place 8. 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 9. Write SQL statement to delete film_id =10, in film table. 10. Retrieve all records in table before_film_delete. WHAT DO YOU OBSERVE Submission: Please submit the query for each one as "text" and the output as "screenshot