DigiGirls-SQL-Assignment

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

1. Are there customers that share the same address?. If yes, display the customer names
2. What is the name of the customer who made the highest total payments?
3. What movie(s) that was rented the most?
4. Which movies have been rented so far?
5. Which movies have not been rented so far?
6. Which customers have not rented any movies so far?
7. Display each movie and the number of times it got rented
8. Show the first name and last name and the number of films each actor acted in
9. Display the names of all the actors that acted in more than 20 movies
10. For all movies rated “PG” how many times did it get rented
11. What movies are offered for rent in store_id 1 and not offered in store_id 2?
12. What movies are offered for rent in any of the two stores 1 and 2?
13. What movies are offered in both stores at the same time?
14. Display the movie title for the most rented movie in the store with store_id 1
15. How many movies are not offered for rent in the stores yet?
16. How many rented movies are under each rating?
17. How much profit have each of the stores 1 and 2 gained?