Answered step by step
Verified Expert Solution
Question
1 Approved Answer
reply asap plz plz Insurance Policy An insurance company has created a new scheme that grants extra claims to people. All eligible people get 1
reply asap plz plz
Insurance Policy
An insurance company has created a new scheme that grants extra claims to people. All eligible people get 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 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
Input format
Table: insurance
tableNameType,DescriptionCUSTOMERIDInt,Represents the customer's idINSURANCETYPE,String,Represents the type of insurance that the customer had takenPREMIUMAMOUNT,Decimal,tableRepresents the premium per month being paid by thecustomer in dollarsCLAIMAMOUNT,Int,tableRepresents the amount of money requested by the customeras a claim in dollarsEMPLOYMENTSTATUS,String,Represents whether the customer is employed or notANYINJURY,String,tableRepresents whether there was any injury that lead to theinsurance claim being filedINCIDENTSEVERITY,String,tableRepresents how severe the incident was that led to the claimbeing filed
Output format
tableNameType,DescriptionCUSTOMERIDInt,GRANTAMOUNT,Float,Represents the amount of money in dollars granted to the customer
Example
Input table
Table: insurance
tableCUSTOMERIDINSURANCETYPE,PREMIUMAMOUNT,CLAIMAMOUNT,EMPLOYMENTSTALife,
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started