Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
You are given a dataset from Instacart, a popular grocery delivery service in the US.
Your goal is to find the top 2 most sold products. If there's a tie, all product names in the top 2 will be included. You will be given the following tables:
orders table:
| Column Name | Description |
|---|---|
| order_id | Unique identifier for each order. |
| user_id | Identifier of the user who placed the order. |
| product_id | Identifier of the product ordered. |
| order_date | Date when the order was placed. |
products table:
| Column Name | Description |
|---|
| id | Unique identifier for each product. |
| product_name | Name of the product. |
| department_id | Identifier of the department to which the product belongs |
| product_name |
|---|
| Juice |
| Cookies |
| Milk |
| Apple |
You are given a dataset from Instacart, a popular grocery delivery service in the US.
Your goal is to find the top 2 most sold products. If there's a tie, all product names in the top 2 will be included. You will be given the following tables:
orders table:
| Column Name | Description |
|---|---|
| order_id | Unique identifier for each order. |
| user_id | Identifier of the user who placed the order. |
| product_id | Identifier of the product ordered. |
| order_date | Date when the order was placed. |
products table:
| Column Name | Description |
|---|---|
| id | Unique identifier for each product. |
| product_name | Name of the product. |
| department_id | Identifier of the department to which the product belongs |
| product_name |
|---|
| Juice |
| Cookies |
| Milk |
| Apple |