Eligible Insurance Claims

Problem Statement

Problem Description An insurance company has created a new scheme that grants an increased payout to eligible policyholders. All eligible customers will be granted 150% of their requested claim amount. To be eligible for the grant, a customer must satisfy all of the following conditions: Their insurance type must be Life ( INSURANCE_TYPE = 'Life' ). There must be no injury reported ( ANY_INJURY = 'N' ). The incident severity must be Major ( INCIDENT_SEVERITY = 'Major' ). The customer must be employed ( EMPLOYMENT_STATUS = 'Y' ). The requested claim amount must be strictly less than 30 times the premium amount ( CLAIM_AMOUNT < 30 * PREMIUM_AMOUNT ). Write a SQL query to find all eligible customers and calculate the claim amount they will be granted. Schema insurance Table Column Name Type Description CUSTOMER_ID INT Represents the customer's unique ID. INSURANCE_TYPE VARCHAR The type of insurance the customer has (e.g., 'Life', 'Property', 'Health'). PREMIUM_AMOUNT DECIMAL The monthl