1. Create a stored procedure that takes a country’s 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 customer’s 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.

  

Name actor address category city country customer film film actor film_category film_text inventory language payment rental staff store Engine InnoDB 10 InnoDB 10 InnoDB 10 InnoDB InnoDB InnoDB InnoDB InnoDB InnoDB InnoDB InnoDB InnoDB Version Row Format Dynamic Dynamic Dynamic Dynamic Dynamic Dynamic Dynamic Dynamic Dynamic InnoDB InnoDB InnoDB InnoDB 2222222222229999 10 10 10 10 10 10 10 10 10 10 10 10 10 Dynamic Dynamic Dynamic Dynamic Dynamic Dynamic Dynamic Rows 200 603 16 600 109 599 1000 5462 1000 1000 4581 6 16086 16005 2 2 Avg Row Length 81 163 1024 81 150 136 196 35 65 180 39 2730 98 99 32768 8192 Data Length 16.0 KB 96.0 KB 16.0 KB 48.0 KB 16.0 KB 80.0 KB 192.0 KB 192.0 KB 64.0 KB 176.0 KB 176.0 KB 16.0 KB 1.5 MB 1.5 MB 64.0 KB 16.0 KB Max Data Length Index Length 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 16.0 KB 16.0 KB 0.0 bytes 16.0 KB 0.0 bytes 48.0 KB 80.0 KB 80.0 KB 16.0 KB 16.0 KB 192.0 KB 0.0 bytes 624.0 KB 1.1 MB 32.0 KB 32.0 KB Data Free 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 4.0 MB 0.0 bytes 0.0 bytes Auto 1