This repository contains code and data related to the analysis of a movie rental database using SQL. The project aims to answer various questions and derive insights from the database. Below is an overview of the key aspects of this analysis
The movie rental database used for this analysis contains information about movie rentals, including details about customers, movies, rentals, and more. SQL queries are employed to extract meaningful information from this dataset.
The analysis focuses on answering several key questions:
- What is the count of rentals for each movie, categorized by film genre?
- What does the distribution of films reveal according to each category's rental duration?
- How do monthly rental order counts compare between the two stores?
- Who were the top 10 paying customers and their 2007 monthly payments?
The dataset for this analysis is available at PostgreSQL Sample Database, comprising tables related to movies, customers, rentals, and more.
SQL queries corresponding to the key questions are provided in the repository to reproduce the analysis.
A PDF document is available that presents visualizations and insights derived from the analysis results. This document provides a comprehensive overview of the movie rental data and its interpretation.
To explore the analysis and results, follow these steps:
- Download the dataset from PostgreSQL Sample Database.
- Use a PostgreSQL database or SQL tool to execute the SQL queries provided in the repository.
- Run the queries to observe detailed insights.
- Refer to the PDF document for visualizations and insights.
This project offers a comprehensive analysis of the movie rental database, answering important questions and providing insights into rental trends, customer behavior, and more. Explore the SQL queries and results to gain a deeper understanding of the data.
For any questions or further information, please reach out to me.
Enjoy exploring the world of movie rentals!