What is the customer name of customer id 9?
select customer_name from customers where customer_id = 9
Find the payment method of Tillman Ernser.
select payment_method from customers where customer_name = "Tillman Ernser"
What are the contact number of customer id 3?
select contact_number from customer_contact_channels where customer_id = 3
What is the "active to date" of the latest contact channel used by "Tillman Ernser"?
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"