Average Claim Amount by Month | Dataford Interview Questions

Write a SQL query to find the average claim amount by month.

Use the claims table and include every month represented in the data. Ignore claim records where the claim amount is NULL.

Output

claims

Column	Type	Description
claim_idPK	INT	Unique identifier for the claim
claim_date	DATE	Date the claim was filed
claim_amount	DECIMAL(12,2)	Financial amount associated with the claim

Your question is Average Claim Amount by Month. Start with the requirements and the one table 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.

Write a SQL query to find the average claim amount by month.

Use the claims table and include every month represented in the data. Ignore claim records where the claim amount is NULL.

claims

Column	Type	Description
claim_idPK	INT	Unique identifier for the claim
claim_date	DATE	Date the claim was filed
claim_amount	DECIMAL(12,2)	Financial amount associated with the claim

Your question is Average Claim Amount by Month. Start with the requirements and the one table 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.