Project information

  • Category: SQL Project
  • Title: Extraction Data
  • Project date: 10 April, 2023
  • Project URL: Extraction Data SQL

Description

By using PostrageSQL, several variables will be searched as follows:

1. The top 10 customers and their email so we can reward them.

2. The bottom 10 customers and their emails.

3. The most profitable movie genres (ratings).

4. The number of movies were returned late, early, and on time.

4. The number of movies were returned late, early, and on time.

5. The customer base in the countries where we have a presence.

6. The most profitable country for the business.

7. The average rental rate per film genre (rating).