Top Customers by Claims | Dataford Interview Questions

Write a SQL query to retrieve the top 10 customers by claim amount at Berkshire Hathaway Guard Insurance Companies. Use the provided customer and claim records, totaling claim amounts for each customer. Customers without matching claims should not appear.

Output

One row per customer with columns customer_id, customer_name, and total_claim_amount.
Include the 10 customers with the highest total claim amount.
Order by total_claim_amount descending, then customer_id ascending to break ties.

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(120)	Customer or insured name

claims

Column	Type	Description
claim_idPK	INT	Unique claim identifier
customer_id	INT	Customer associated with the claim
claim_amount	DECIMAL(12,2)	Monetary amount of the claim
claim_date	DATE	Date the claim was recorded

Your question is Top Customers by Claims. 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