What are all the policy types of the customer that has the most policies listed?
select distinct t3.policy_type_code from customers as t1 join customers_policies as t2 on t1.customer_id = t2.customer_id join available_policies as t3 on t2.policy_id = t3.policy_id where t1.customer_name = ( select t1.customer_name from customers as t1 join customers_policies as t2 on t1.customer_id = t2.customer_id group by t1.customer_name order by count ( * ) desc limit 1 )
What is the name of the customer?
select t1.customer_name from customers as t1 join customers_policies as t2 on t1.customer_id = t2.customer_id group by t1.customer_name order by count ( * ) desc limit 1
what is the phone number for life insurance?
select customer_phone from available_policies where policy_type_code = "Life Insurance"