Lab | SQL Join

In this lab, you will be using the Sakila database of movie rentals.The database is structured as follows:

Instructions

1. List the number of films per category.
2. Display the first and the last names, as well as the address, of each staff member.
3. Display the total amount rung up by each staff member in August 2005.
4. List all films and the number of actors who are listed for each film.
5. Using the payment and the customer tables as well as the JOIN command, list the total amount paid by each customer. List the customers alphabetically by their last names.