Eligible Insurance Claims

Problem Statement

Eligible Insurance Claims An insurance company has launched a new scheme that pays an increased amount to eligible policyholders. Every eligible customer is granted 150% of the claim amount they requested. The company's records are stored in the table insurance . Write an SQL query that finds every eligible customer and the amount they will be granted. Table: insurance Column Data Type Description CUSTOMER_ID INT The customer's unique id INSURANCE_TYPE VARCHAR The type of insurance the customer has taken: 'Life' , 'Health' , 'Property' or 'Travel' PREMIUM_AMOUNT DECIMAL(10,2) The premium the customer pays per month, in dollars CLAIM_AMOUNT INT The amount of money the customer requested as a claim, in dollars EMPLOYMENT_STATUS VARCHAR The customer's employment status flag: 'Y' or 'N' ANY_INJURY VARCHAR Whether an injury was reported with the claim: 'Y' or 'N' INCIDENT_SEVERITY VARCHAR How severe the incident behind the claim was: 'Major' or 'Minor' Eligibility A customer is eligible onl