-- Database schema
| Customers : Customer_ID [ INT ] primary_key , Customer_Details [ TEXT ] | Customer_Policies : Policy_ID [ INT ] primary_key , Customer_ID [ INT ] Customer_Policies.Customer_ID = Customers.Customer_ID , Policy_Type_Code [ TEXT ] , Start_Date [ TEXT ] , End_Date [ TEXT ] | Claims : Claim_ID [ INT ] primary_key , Policy_ID [ INT ] Claims.Policy_ID = Customer_Policies.Policy_ID , Date_Claim_Made [ TEXT ] , Date_Claim_Settled [ TEXT ] , Amount_Claimed [ INT ] , Amount_Settled [ INT ] | Settlements : Settlement_ID [ INT ] primary_key , Claim_ID [ INT ] Settlements.Claim_ID = Claims.Claim_ID , Date_Claim_Made [ TEXT ] , Date_Claim_Settled [ TEXT ] , Amount_Claimed [ INT ] , Amount_Settled [ INT ] , Customer_Policy_ID [ INT ] | Payments : Payment_ID [ INT ] primary_key , Settlement_ID [ INT ] Payments.Settlement_ID = Settlements.Settlement_ID , Payment_Method_Code [ TEXT ] , Date_Payment_Made [ TEXT ] , Amount_Payment [ INT ] |
-- -- Give me the the customer details and id for the customers who had two or more policies but did not file any claims.

SELECT T1.customer_details ,  T1.customer_id FROM Customers AS T1 JOIN Customer_Policies AS T2 ON T1.Customer_id  =  T2.customer_id GROUP BY T1.customer_id HAVING count(*)  >=  2 EXCEPT SELECT T1.customer_details ,  T1.customer_id FROM Customers AS T1 JOIN Customer_Policies AS T2 ON T1.Customer_id  =  T2.customer_id JOIN Claims AS T3 ON T2.policy_id  =  T3.policy_id;