Which kind of policy type was chosen by the most customers?
select policy_type_code from customer_policies group by policy_type_code order by count ( * ) desc limit 1
what about the least?
select policy_type_code from customer_policies group by policy_type_code order by count ( * ) limit 1
What is Policy_Type_Code of Customer_ID 3?
select policy_type_code from customer_policies where customer_id = '3'
What is the Start Date of Policy ID 143?
select start_date from customer_policies where policy_id = '143'
What is the Policy ID of Policy Type Life?
select policy_id from customer_policies where policy_type_code = 'Life'