All are meant to use the Sakila Database and answered in SQLite.

1. What is the average number of actors appearing in all movies in the Sakila Database using SQLite?

2. How many movies are there in each category? Order the list by category name alphabetically.

3. Which movies arent currently in the inventory of any of the stores? Provide a list of film titles in alphabetical order along with the name of the category that each film belongs to.

4. The company wants to start a VIP Customer Loyalty program. Any customer who has rented more than 35 movies will be invited to join. Generate a list of all customers that have rented more than 35 movies. Order the list in descending order by number of rentals.

5. Which actors or actresses have starred in movies from every category of film in our inventory? The output should give the last name and first name of these actors alphabetically.

6. Are there any actors or actresses that have the same first name and last name? If so, give the actors id numbers and names.

7. Help! One of our customers just called and is looking for the name of a particular movie. This customer was talking to her next door neighbor who was raving about this movie, but cant remember the name. The neighbor remembered that the movie was really long over 3 hours, and they rented it sometime in the 2nd half of 2005. There was also an actor or actress in the movie with a last name similar to MacCallen or McKellen or McKallen or something like that they couldnt really remember. Our customers neighbor really only like Sci-fi and horror films. So, the movie is almost certainly in one of those two categories.