Python, SQL, and Excel Experience | Dataford Interview Questions

python and sql and excel

For the SQL portion, use the supplied customers and applications tables to summarize 2025 approved applications. Include customers meeting both approval-count and approved-amount thresholds. Rows with a NULL submitted_at or requested_amount are ignored for the relevant calculations.

Output

One row per qualifying customer with customer_name, approved_application_count, approved_amount, and amount_band.
Include customers with at least 2 approved applications and more than 10,000 in approved amount.
Sort by approved_amount descending, then customer ID ascending.

Schema

customers

Column	Type	Description
customer_idPK	INTEGER	Unique customer identifier
customer_name	VARCHAR(100)	Customer's full name

applications

Column	Type	Description
application_idPK	INTEGER	Unique application identifier
customer_id	INTEGER	Customer associated with the application
status	VARCHAR(40)	Application decision status
submitted_at	DATE	Date the application was submitted
requested_amount	NUMERIC(12,2)	Amount requested by the customer

Your question is Python, SQL, and Excel 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