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'
customers that use email as the contact channel refers to WHERE channel_code = 'Email'; name and active to date of the customers refers to SELECT customer_name, active_to_date; JOIN is used to link customers table with customer_contact_channels table on customer_id.