Database: customers_and_products_contacts
Question: Show the customer name, customer address city, date from, and date to for each customer address history.
SQL:
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