Project information
- Title: Basic SQL Query with PostgreSQL
- Language: SQL
- Tools: PostgreSQL
- Project date: 9 May, 2023
- Project URL: Basic SQL Query with PostgreSQL
Detail information
The database used in this case study is the dvdrental database. PostgreSQL is utilized to address the following issues:
- 1. Identify the top 10 customers and their email so we can reward them
- 2. Identify the bottom 10 customers and their emails
- 3. What are the most profitable movie genres (ratings)?
- 4. How many rented movies were returned late, early, and on time?
- 5. What is the customer base in the countries where we have a presence?
- 6. Which country is the most profitable for the business?
- 7. What is the average rental rate per movie genre (rating)?