What is the name of the customer who was involved in the most policies, please?
select t2.customer_details from policies as t1 join customers as t2 on t1.customer_id = t2.customer_id group by t2.customer_details order by count ( * ) desc limit 1
What is her customer id?
select t2.customer_id, t2.customer_details from policies as t1 join customers as t2 on t1.customer_id = t2.customer_id group by t2.customer_details order by count ( * ) desc limit 1
What are her customer details, please?
select t2.customer_id, t2.customer_details from policies as t1 join customers as t2 on t1.customer_id = t2.customer_id group by t2.customer_details order by count ( * ) desc limit 1
What is her policy type code?
select policy_type_code from policies where customer_id = 380
What is her start date for each of those?
select policy_type_code,start_date from policies where customer_id = 380
How about the end date, please?
select policy_type_code,start_date,end_date from policies where customer_id = 380