Show the date from and date to for each customer address history.
select date_from, date_to from customer_address_history
For each of those records, also show the customer name.
select t2.customer_name, t1.date_from, t1.date_to from customer_address_history as t1 join customers as t2 on t1.customer_id = t2.customer_id
For each of those, also show the customer address city.
select t2.customer_name, t3.city, t1.date_from, t1.date_to from customer_address_history as t1 join customers as t2 on t1.customer_id = t2.customer_id join addresses as t3 on t1.address_id = t3.address_id