In this project, I queried the Sakila DVD Rental database. The Sakila Database holds information about a company that rents movie DVDs.
Investigate a Relational Database.
- All four of your final submitted queries should contain a JOIN and AGGREGATION.
- At least two of your final submitted queries should contain either a subquery OR a CTE.
- At least one of your final submitted queries should contain a Window Function.
- At least one column generated by the Window Function should be included in one of your final visualization.
- Four slides
- One question on each slide
- One visualization (graph / chart / table) per slide
- A 1-2 sentence answer to the question, based on the data and visualization, on each slide
- Indicate which code in the attached text file was used to create the visualization OR add the query used to generate the visualization.
The DVD rental database represents the business processes of a DVD rental store. To know more about the database, click here
