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