hi I was wondering how many policies Ellsworth Paucek has?
select count ( * ) from customers as t1 join customer_policies as t2 on t1.customer_id = t2.customer_id where t1.customer_details = "Ellsworth Paucek"
do you know how many total customers had more than 1 policy?
select count ( * ) from ( 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 ( * ) > 1 )
could you tell me those four customer's details and their 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 ( * ) > 1