Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
### Context:
CREATE TABLE customers (customer_name VARCHAR, customer_id VARCHAR, customer_address VARCHAR)
### Question:
What are the names and ids of customers whose address contains TN?
### Answer:
SELECT customer_name, customer_id FROM customers WHERE customer_address LIKE "%TN%"