SQL for High-Value Tax Returns | Dataford Interview Questions

Write a SQL query to retrieve all customers with tax returns above a certain threshold at Jackson Hewitt.

Use $10,000 as the threshold. Treat a NULL return amount as zero and include only customers whose combined return amount is greater than the threshold.

Output

One row per qualifying customer with customer_id, customer_name, and total_return_amount.
Exclude customers at or below the threshold and customers without tax return records.
Order by total_return_amount descending, then customer_id ascending.

Schema

customers

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

tax_returns

Column	Type	Description
return_idPK	INT	Unique tax return record identifier
customer_id	INT	Customer associated with the tax return
tax_year	INT	Tax year for the return
return_amount	NUMERIC(12,2)	Tax return amount, which may be NULL

Your question is SQL for High-Value Tax Returns. 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