Business Question From CSV | Dataford Interview Questions

The interviewer gives you a CSV and asks you to answer a business question using whatever tools you want; how do you approach it from start to finish?

For grading, assume the CSV has been loaded into csv_sales and customer reference data is available in customer_segments. Return completed, non-null sales from Q1 2025, grouped by customer segment, with unknown customers labeled Unclassified. Include only segments with at least two qualifying sales.

Output

One row per qualifying segment with segment, completed_orders, net_sales, and avg_order_value
Net sales equal amount minus discount, treating a missing discount as zero
Order by net_sales descending, then segment ascending

Schema

csv_sales

Column	Type	Description
order_idPK	INT	Unique sales record identifier
customer_id	INT	Customer identifier from the CSV
order_date	DATE	Date of the sales record
amount	DECIMAL(12,2)	Gross sales amount
discount	DECIMAL(12,2)	Discount applied to the sale
status	VARCHAR(20)	Sales record status

customer_segments

Column	Type	Description
customer_idPK	INT	Unique customer identifier
segment	VARCHAR(40)	Customer segment label

Your question is Business Question From CSV. Start with the requirements and the two 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