Untitled

 avatar
unknown
mysql
2 years ago
256 B
4
Indexable
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);
Editor is loading...