What is the channel code and contact number of the customer contact channel that was active for the longest time?
CREATE TABLE customer_contact_channels (
    channel_code VARCHAR,
    contact_number VARCHAR,
    active_to_date VARCHAR,
    active_from_date VARCHAR
)
SELECT channel_code, contact_number FROM customer_contact_channels WHERE active_to_date - active_from_date = (SELECT active_to_date - active_from_date FROM customer_contact_channels ORDER BY (active_to_date - active_from_date) DESC LIMIT 1)
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is the channel code and contact number of the customer contact channel that was active for the longest time? ### Input: CREATE TABLE customer_contact_channels (
    channel_code VARCHAR,
    contact_number VARCHAR,
    active_to_date VARCHAR,
    active_from_date VARCHAR
) ### Response: SELECT channel_code, contact_number FROM customer_contact_channels WHERE active_to_date - active_from_date = (SELECT active_to_date - active_from_date FROM customer_contact_channels ORDER BY (active_to_date - active_from_date) DESC LIMIT 1)