For each contact channel, find when it started and ended being active.
select active_to_date, active_from_date from customer_contact_channels
What is the time span between the starting date and ending date?
select active_to_date - active_from_date from customer_contact_channels
What is the average across all the channels?
select avg(active_to_date - active_from_date) from customer_contact_channels