Untitled

mail@pastecode.io avatar
unknown
mysql
6 months ago
256 B
1
Indexable
Never
SELECT CUSTOMER_ID,
       PREMIUM_AMOUNT * 1.5 AS GRANT_AMOUNT
FROM insurance
WHERE INSURANCE_TYPE = 'Life'
  AND ANY_INJURY = 'No'
  AND INCIDENT_SEVERITY = 'Major'
  AND EMPLOYMENT_STATUS = 'Employed'
  AND CLAIM_AMOUNT < (PREMIUM_AMOUNT * 30);