#SQL Programs for Project 1 Submittal
Programming for Data Science with Python
Project1 - Dec 31, 2020
Project2 - Dec 31, 2020
Project3 - Dec 31, 2020
Project4 - Dec 31, 2020
PostgreSQL v13
pgAdmin v4.28
Python v3.8.3
DVD Rental Data Analysis
Query 1 - A query that lists each movie in the family category (Animation, Children, Classics, Comedy, Family and Music), the film category it is classified in, and the number of times it has been rented out.
Query 2 - A query that provides a table with the movie titles divided into 4 levels (first_quarter, second_quarter, third_quarter, and final_quarter) based on the quartiles (25%, 50%, 75%) of the rental duration for movies across all categories.
Query 3 - A query that returns the store ID for the store, the year and month and the number of rental orders each store has fulfilled for that month.
Query 4 - A query to capture the customer name, month and year of payment, and total payment amount for each month by top 10 paying customers.
DVD rental csv DVD Rental Entity Relationship Diagram (erd)