Answered step by step
Verified Expert Solution
Link Copied!

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 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
Input format
Table: insurance
\table[[Name,Type,Description],[CUSTOMER_ID,Int,Represents the customer's id],[INSURANCE_TYPE,String,Represents the type of insurance that the customer had taken],[PREMIUM_AMOUNT,Decimal,\table[[Represents the premium (per month) being paid by the],[customer (in dollars)]]],[CLAIM_AMOUNT,Int,\table[[Represents the amount of money requested by the customer],[as a claim (in dollars)]]],[EMPLOYMENT_STATUS,String,Represents whether the customer is employed or not],[ANY_INJURY,String,\table[[Represents whether there was any injury that lead to the],[insurance claim being filed]]],[INCIDENT_SEVERITY,String,\table[[Represents how severe the incident was that led to the claim],[being filed]]]]
Output format
\table[[Name,Type,Description],[CUSTOMER_ID,Int,],[GRANT_AMOUNT,Float,Represents the amount of money (in dollars) granted to the customer]]
Example
Input table
Table: insurance
\table[[CUSTOMER_ID,INSURANCE_TYPE,PREMIUM_AMOUNT,CLAIM_AMOUNT,EMPLOYMENT_STA],[1,Life,157.13,9000,Y
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions