Write a SQL query using window functions to calculate a running total of processed Asurion insurance claims by day.
Use the claims and claim processing events tables. Include only successfully processed events with a valid processing timestamp.
processed_date, processed_claims, and running_totalprocessed_date ascending| Column | Type | Description |
|---|---|---|
| claim_idPK | INT | Unique insurance claim identifier |
| claim_number | VARCHAR(20) | External claim reference number |
| device_type | VARCHAR(40) | Type of device covered by the claim |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique processing event identifier |
| claim_id | INT | Claim associated with the processing event |
| status | VARCHAR(20) | Processing status |
| processed_at | TIMESTAMP | Timestamp when the event was processed |