Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
You just joined Amazon as a Data Analyst and you're being asked to find the number of buyers on the platform for the month of March 2023. To answer this, you will need 2 tables: customers and orders:
customers: This table contains information about each customer.
| Column Name | Description |
|---|---|
| customer_id | Unique identifier for a customer |
| name | The customer's full name |
| The customer's email address |
orders: This table tracks each order placed by customers.
| Column Name |
|---|
| order_id | Unique identifier for an order |
| customer_id | ID of the customer who placed the order |
| product_id | ID of the product ordered |
| order_date | Date when the order was placed |
| nb_buyers |
|---|
| 9 |
You just joined Amazon as a Data Analyst and you're being asked to find the number of buyers on the platform for the month of March 2023. To answer this, you will need 2 tables: customers and orders:
customers: This table contains information about each customer.
| Column Name | Description |
|---|---|
| customer_id | Unique identifier for a customer |
| name | The customer's full name |
| The customer's email address |
orders: This table tracks each order placed by customers.
| Column Name | Description |
|---|---|
| order_id | Unique identifier for an order |
| customer_id | ID of the customer who placed the order |
| product_id | ID of the product ordered |
| order_date | Date when the order was placed |
| nb_buyers |
|---|
| 9 |