List the names of all the customers that use email as a contact channel.
select t1.customer_name from customers as t1 join customer_contact_channels as t2 on t1.customer_id = t2.customer_id where t2.channel_code = 'Email'
List the names of all the customers that use email as a contact channel and the date they became a member.
select t1.customer_name, t1.date_became_customer from customers as t1 join customer_contact_channels as t2 on t1.customer_id = t2.customer_id where t2.channel_code = 'Email'
Find the name and active to date of the customers that use email as the contact channel.
select t1.customer_name, t2.active_to_date from customers as t1 join customer_contact_channels as t2 on t1.customer_id = t2.customer_id where t2.channel_code = 'Email'
What is the payment method of Devin Mills.
select distinct t1.payment_method from customers as t1 join customer_contact_channels as t2 on t1.customer_id = t2.customer_id where t1.customer_name = "Devin Mills"
What is the customer id of Devin Mills.
select distinct t1.customer_id from customers as t1 join customer_contact_channels as t2 on t1.customer_id = t2.customer_id where t1.customer_name = "Devin Mills"
List the names of all the customers with the same payment method as Devin Mills.
select distinct t1.customer_name from customers as t1 join customer_contact_channels as t2 on t1.customer_id = t2.customer_id where t1.payment_method = ( select distinct t1.payment_method from customers as t1 join customer_contact_channels as t2 on t1.customer_id = t2.customer_id where t1.customer_name = "Devin Mills" )