Schema: 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?
SQL: SELECT customer_name, customer_id FROM customers WHERE customer_address LIKE "%TN%"