Here I explore the dvdrental database which holds information on the stores, inventory, customers, films, film actors etc. of a film rental company and answer the following questions with SQL
- Are there customers that share the same address?. If yes, display the customer names
- What is the name of the customer who made the highest total payments?
- What movie(s) that was rented the most?
- Which movies have been rented so far?
- Which movies have not been rented so far?
- Which customers have not rented any movies so far?
- Display each movie and the number of times it got rented
- Show the first name and last name and the number of films each actor acted in
- Display the names of all the actors that acted in more than 20 movies
- For all movies rated “PG” how many times did it get rented
- What movies are offered for rent in store_id 1 and not offered in store_id 2?
- What movies are offered for rent in any of the two stores 1 and 2?
- What movies are offered in both stores at the same time?
- Display the movie title for the most rented movie in the store with store_id 1
- How many movies are not offered for rent in the stores yet?
- How many rented movies are under each rating?
- How much profit have each of the stores 1 and 2 gained?