names please
select distinct customer_name, channel_code from customers as t1 join customer_contact_channels as t2 on t1.customer_id = t2.customer_id
please show just those customers who's channel code was email
select distinct customer_name from customers as t1 join customer_contact_channels as t2 on t1.customer_id = t2.customer_id where channel_code = "Email"
Please list just Tillman Ernsers contact channel
select distinct channel_code from customers as t1 join customer_contact_channels as t2 on t1.customer_id = t2.customer_id where customer_name = "Tillman Ernser"