Working in a Group With SQL and Python | Dataford Interview Questions

Describe a time you had to work in a group using simple SQL and Python pandas code.

For the hands-on portion, explain how you would combine customer and order data to report completed activity during the first quarter of 2025. Include how you would handle customers without qualifying orders and missing order values.

Output

One row per customer, including customers with no qualifying orders.
Columns: customer_id, customer_name, completed_orders, and completed_revenue.
Include only completed orders dated from 2025-01-01 through 2025-03-31.
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 display name

orders

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

Your question is Working in a Group With SQL and Python. 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