Database: customers_and_addresses
Question: Find the contact channel code that was used by the customer named "Tillman Ernser".
SQL:
SELECT DISTINCT channel_code FROM customers AS t1 JOIN customer_contact_channels AS t2 ON t1.customer_id  =  t2.customer_id WHERE t1.customer_name  =  "Tillman Ernser"