• 1. What is the average number of actors that have acted all movies?
• 2. How many movies are there in each category. order the list by category name alphabetically.
• 3. Which movies aren’t currently in the inventory of any of the stores? Provide a list of film titles in alphabetic order along with the name of the category that each film belongs to. (This one is really similar to one on the website below… fyi)
• 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 can’t 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 couldn’t really remember. Our customer’s neighbor really only like Sci-fi and horror films. So, the movie is almost certainly in one of those two categories.