ACTIVITY 3 – ADVANCED SQL

1. Execute the following queries:

i. Total amount paid by customers that paid above $5.

ii. Total number of customers in the payment table.

iii. Number of distinct staff id in the payment table.

1. Display the customer names that share the same address (e.g. husband and wife).

2. What is the name of the customer who made the highest total payments.

3. What is the movie(s) that was rented the most.

4. Which movies have been rented so far.

5. Which movies have not been rented so far.

6. Which customers have not rented any movies so far.

7. Display each movie and the number of times it got rented.

8. Show the first name and last name and the number of films each actor acted in.