Practice Interview Questions
| Question | Status |
|---|---|
You have a transactional dataset from Amazon, detailing sales across various products and marketplaces. Your objective is to identify and list the top 3 sellers in each product category for the month of January.
sales_data table:
| Column Name | Description |
|---|---|
| seller_id | Identifier of seller |
| total_sales | Total sales |
| product_category | Category of product |
| market_place | Market place |
| month | Month |
Example output:
| seller_id | total_sales | product_category | market_place | month |
|---|---|---|---|---|
| s195 | 45633.35 | books | de | 2024-01 |
| s728 | 29158.51 | books | us | 2024-01 |
| s918 | 24286.4 | books | uk | 2024-01 |
You have a transactional dataset from Amazon, detailing sales across various products and marketplaces. Your objective is to identify and list the top 3 sellers in each product category for the month of January.
sales_data table:
| Column Name | Description |
|---|---|
| seller_id | Identifier of seller |
| total_sales | Total sales |
| product_category | Category of product |
| market_place | Market place |
| month | Month |
Example output:
| seller_id | total_sales | product_category | market_place | month |
|---|---|---|---|---|
| s195 | 45633.35 | books | de | 2024-01 |
| s728 | 29158.51 | books | us | 2024-01 |
| s918 | 24286.4 | books | uk | 2024-01 |