Practice Interview Questions
| Question | Status |
|---|---|
As an analyst at Shopify, your task is to uncover the product that has received the highest number of orders from users in Germany. In case of a tie, you should display all products sharing the top spot.
orders table:
| Column Name | Description |
|---|---|
| order_id | Unique identifier for each order. |
| shop_id | Shop Identifier where the order was placed |
| user_id | Identifier for the user who placed the order |
| order_amount | Total amount of the order |
users table:
| Description |
|---|
| id | Unique identifier for each user |
| username | The username of the user |
| country | The country where the user is located |
products table:
| Column Name | Description |
|---|---|
| prod_sku_id | Identifier for the product |
| prod_sku_name | Name of the product |
| prod_brand | Brand of the product |
| market_name | The detailed product name |
product_orders table:
| Column Name | Description |
|---|---|
| order_id | Identifier for the order |
| product_id | Identifier for the product |
| market_name |
|---|
| iPhone 12 |
As an analyst at Shopify, your task is to uncover the product that has received the highest number of orders from users in Germany. In case of a tie, you should display all products sharing the top spot.
orders table:
| Column Name | Description |
|---|---|
| order_id | Unique identifier for each order. |
| shop_id | Shop Identifier where the order was placed |
| user_id | Identifier for the user who placed the order |
| order_amount | Total amount of the order |
users table:
| Column Name | Description |
|---|---|
| id | Unique identifier for each user |
| username | The username of the user |
| country | The country where the user is located |
products table:
| Column Name | Description |
|---|---|
| prod_sku_id | Identifier for the product |
| prod_sku_name | Name of the product |
| prod_brand | Brand of the product |
| market_name | The detailed product name |
product_orders table:
| Column Name | Description |
|---|---|
| order_id | Identifier for the order |
| product_id | Identifier for the product |
| market_name |
|---|
| iPhone 12 |