text: 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%"