Using mysql sakila (defult database

1. Create a stored procedure that takes a countrys name as the input parameter and outputs the details of customers in it (customer_id, first_name, last_name).

2. Create a stored procedure that takes a customer_id and returns that customers rental and payment history. (display on screen)

3. Look at the triggers on the film table. Understand each one of them and summarize in a couple of lines what they do.

4. Write a stored procedure that takes in a film_id and outputs useful details such as category, actors, film_text, etc.

5. Create a stored procedure that creates a list of customers that have a rental_id, but no payment_id. That is, those customers who have not paid.