1. Retrieve the 'Rating' that has the minimum number of films. 2. For each category, retrieve the language that has the maximum number of films in each category. 3. Create table customer_audit with 5 attributes: - id which is auto increment and primary key - customernumber integer must be not null - lastname with 50 characters and must be not null - changedate which is datetime type, default null - action with 50 characters, default null 4. Create a trigger name before_customer_update, which will be called before any update on customer for each row. The trigger will insert into customer_audit table where: action = update customernumber will be old custumer_id lastname will be old lastname changedate will the current time and date of the update prosses. 5. Write SQL statement to update (change) the last name of customer from "JONES" to "JON" in customer table. 6. Retrieve all records in table customer_audit. WHAT DO YOU OBSERVE 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