What data project have you conducted?
Use the provided TikTok Shop tables to demonstrate a concise seller-performance data project. Calculate completed-order performance and retain only sellers meeting the minimum order threshold.
seller_id, seller_name, completed_orders, completed_gmv, and average_order_value.completed_gmv descending, then seller_id ascending.| Column | Type | Description |
|---|---|---|
| seller_idPK | INT | TikTok Shop seller identifier |
| seller_name | VARCHAR(100) | Seller display name |
| Column | Type | Description |
|---|---|---|
| order_idPK | INT | Order identifier |
| seller_id | INT | Seller associated with the order |
| status | VARCHAR(20) | Order lifecycle status |
| order_date | DATE | Order creation date |
| Column | Type | Description |
|---|---|---|
| order_item_idPK | INT | Order item identifier |
| order_id | INT | Parent order identifier |
| sku | VARCHAR(40) | Product SKU |
| quantity | INT | Units purchased |
| unit_price | NUMERIC(10,2) | Price per unit |