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 TOP 1 active_to_date - active_from_date FROM customer_contact_channels ORDER BY (active_to_date - active_from_date) DESC)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE customer_contact_channels (channel_code VARCHAR, contact_number VARCHAR, active_to_date VARCHAR, active_from_date VARCHAR) Question: What is the channel code and contact number of the customer contact channel that was active for the longest time? [/INST] SELECT channel_code, contact_number FROM customer_contact_channels WHERE active_to_date - active_from_date = (SELECT TOP 1 active_to_date - active_from_date FROM customer_contact_channels ORDER BY (active_to_date - active_from_date) DESC) </s>