Join Us
Loading Similar Posts
Entering edit mode
Question: Insurance Policy (SQL Query)
Problem Statement:
An insurance company has created a new scheme that grants extra claims to people. All eligible people get 150% of their asked claim.
To be eligible for the claim a person must satisfy the following conditions:
- It is valid only for Life Insurance.
- There must be no injury reported.
- It should have a major incident severity.
- The customer must be employed.
- Lastly, the claim amount has to be less than 30 times the premium amount.
You are given the table insurance.
Task:
Write a query to find all the eligible people and the claim they will be granted.
Table Description:
Table: insurance
Name | Type | Description |
CUSTOMER_ID | Int | Represents the customer's id |
INSURANCE_TYPE | String | Represents the type of insurance that the customer had |
(Note: Other columns like injury status, severity, employment status, claim amount, and premium amount are implied to exist based on the conditions but are cut off from the schema view). |
Expected Output Format:
The output should return two columns: CUSTOMER_ID and GRANT_AMOUNT.
Example Output:
CUSTOMER_ID GRANT_AMOUNT
6 3750.0
