Tell me the claims id of the customer named Ellsworth Paucek.
select t3.claim_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 where t1.customer_details = "Ellsworth Paucek"
Tell me the number of policies of the customer named Ellsworth Paucek.
select count(*) from customers as t1 join customer_policies as t2 on t1.customer_id = t2.customer_id where t1.customer_details = "Ellsworth Paucek"
Which customer had at least 2 policies but did not file any claims? List the customer details and id.
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