What are the names and ids of customers whose address contains TN?
CREATE TABLE customers (
    customer_name VARCHAR,
    customer_id VARCHAR,
    customer_address VARCHAR
)
SELECT customer_name, customer_id FROM customers WHERE customer_address LIKE "%TN%"
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 are the names and ids of customers whose address contains TN? ### Input: CREATE TABLE customers (
    customer_name VARCHAR,
    customer_id VARCHAR,
    customer_address VARCHAR
) ### Response: SELECT customer_name, customer_id FROM customers WHERE customer_address LIKE "%TN%"