In this lab, you will be using the Sakila database of movie rentals.
- List number of films per
category
. - Display the first and last names, as well as the address, of each staff member.
- Display the total amount rung up by each staff member in August of 2005.
- List each film and the number of actors who are listed for that film.
- Using the tables
payment
andcustomer
and the JOIN command, list the total paid by each customer. List the customers alphabetically by last name.