Using mysql workbench sakila

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.

Engine Version Row Format InnoDB 10 InnoDB 10 Dyamic nnoDB 10 InnoDB 10 Dynamic InnoDB 10 InnoDB 10 Dynamic nnoDB 10 Dyamic InnoDB 10 nmic nnoDB 10 nmic InnoDB 10 Dynamic nnoDB 10 InnoDB 10 nnoDB 10 InnoDB 10 nnoDB 10 InnoDB 10 Avg Row Length Data Length Max Data Length Index Length Data e Auto 1 0.0 bytes 0.0 bytes 0.0 bytes 0.0 bytes 0.0 bytes 0.0 bytes 0.0 bytes 0.0 bytes 0.0 bytes 0.0 bytes 0.0 bytes 0.0 bytes 0.0 bytes 0.0 bytes 0.0 bytes 0.0 bytes actor address category 16.0 KB 96.0 KB 16.0 KB 48.0 KB 16.0 KB 80.0 KB 192.0 KB 192.0 KB 16.0 KB 0.0 bytes 16.0 KB 0.0 bytes 0bytes 0.0 bytes 16.0 KB 0.0bytes 0.0 bytes 0.0 bytes 48.0 KB 0.0 bytes 0.0 KB 0.0 bytes 80.0 KB 0.0bytes 16.0 KB 0.0 bytes 16.0 KB 0.0 bytes 92.0 KB 0.0 bytes 0.0 bytes 624.0 KB0.0bytes 4.0 MB 32.0 KB 0.0bytes 32.0 KB 0.0bytes country customer film actor film_category film text inventory anguage 176.0 KB 176.0 KB 0.0 bytes 1.5 MB 1.5MB 64.0 KB 16.0 KB 1.1 MB