Write a SQL query to retrieve records from a claims table joined with a member details table, filtering for active members only.
Return one row per matching claim. Include the claim identifier, member identifier, member name, claim amount, and service date.
claim_id, member_id, member_name, claim_amount, service_dateActiveclaim_id in ascending order| Column | Type | Description |
|---|---|---|
| claim_idPK | INT | Unique identifier for the claim |
| member_id | INT | Member associated with the claim |
| claim_amount | DECIMAL(10,2) | Amount submitted for the claim |
| service_date | DATE | Date on which the service occurred |
| claim_type | VARCHAR(50) | Category of the claim |
| Column | Type | Description |
|---|---|---|
| member_idPK | INT | Unique identifier for the member |
| member_name | VARCHAR(100) | Member's name |
| member_status | VARCHAR(20) | Current membership status |