Untitled
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...