Your Data Project | Dataford Interview Questions

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.

Output

One row per seller with at least two completed orders.
Columns: seller_id, seller_name, completed_orders, completed_gmv, and average_order_value.
Sort by completed_gmv descending, then seller_id ascending.

Schema

sellers

Column	Type	Description
seller_idPK	INT	TikTok Shop seller identifier
seller_name	VARCHAR(100)	Seller display name

orders

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

order_items

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

Your question is Your Data Project. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem