SQL for Average Claim Amount | Dataford Interview Questions

Write a SQL query to find the average claim amount per customer for the last year for Kin Insurance.

Use the trailing 12 months ending on CURRENT_DATE. Include only customers with at least one non-null claim amount during that period.

Output

One row per qualifying customer.
Columns: customer_id, customer_name, and average_claim_amount.
Round the average to two decimal places and order by average amount descending, then customer_id ascending.

customers

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

claims

Column	Type	Description
claim_idPK	INT	Unique claim identifier
customer_id	INT	Customer associated with the claim
claim_date	DATE	Date the claim was recorded
claim_amount	NUMERIC(12,2)	Claim amount in US dollars

Your question is SQL for Average Claim Amount. 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.