Barclays OnCampus OA 2026 | Insurance Policy SQL Query | Database Assessment | Complete Solutions & Tips | SQL Data Filtering & Conditional Logic | Jul 30th Campus Assessment

Question: Insurance Policy (SQL Query) Problem Statement: 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 ...