Python and SQL Experience | Dataford Interview Questions

What is your experience level about Python and SQL?

For the SQL portion, write a query using the provided customer and order data. Return customers who have at least two completed orders, including their completed order count, completed revenue, and a spending segment.

Output

One row per qualifying customer with customer_id, customer_name, completed_order_count, completed_revenue, and spending_segment.
Include only customers with at least two completed orders.
Classify customers with completed revenue of at least 150 as priority; classify all others as standard.
Order by completed revenue descending, then customer ID ascending.

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer name

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	Customer associated with the order
status	VARCHAR(20)	Order status
amount	NUMERIC(10,2)	Order amount

Your question is Python and SQL Experience. 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