Python Coding Task | Dataford Interview Questions

Write code in Python to solve the given problem.

For this SQL version, use the provided customers and payments tables. Return every customer with their qualifying payment count and total amount for Q1 2025.

Output

One row per customer, including customers with no qualifying payments.
Columns: customer_id, customer_name, qualified_payment_count, qualified_payment_total.
Include only payments with status approved, dates from 2025-01-01 through 2025-03-31, and non-null positive amounts.
Sort by qualified_payment_total descending, then customer_id ascending.

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer display name
segment	VARCHAR(30)	Optional customer segment

payments

Column	Type	Description
payment_idPK	INT	Unique payment identifier
customer_id	INT	Customer associated with the payment
payment_date	DATE	Payment processing date
status	VARCHAR(20)	Payment processing status
amount	NUMERIC(12,2)	Payment amount
payment_channel	VARCHAR(20)	Channel used for the payment

Your question is Python Coding Task. 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