This project was created on September 15, 2019 and the README file was created on January 22, 2020.
The project is titled DVD Rental Database Query
The project is a query of Sakila DVD Rental database to answer four questions as posed by an imaginary business manager who wishes to :
-
Know the total rental order per Family-friendly movie(Family-friendly movies are assumed to be films that fall under the following categories: Animation, Children, Classics, Comedy Family, Music).
-
Compare the length of Family-friendly movies rental duration to all the movies put together.
-
Have an overview of the variation in length of rental duration among Family-friendly movie categories.
-
Know who the top ten highest paying customers are and the total amount they paid per movie rental order in the year 2007.