Database: customers_and_addresses
Question: Return the the "active to date" of the latest contact channel used by the customer named "Tillman Ernser".
SQL:
SELECT max(t2.active_to_date) FROM customers AS t1 JOIN customer_contact_channels AS t2 ON t1.customer_id  =  t2.customer_id WHERE t1.customer_name  =  "Tillman Ernser"