What are the names and ids of customers whose address contains TN?
CREATE TABLE customers (customer_name VARCHAR, customer_id VARCHAR, customer_address VARCHAR)
[SQL] SELECT customer_name, customer_id FROM customers WHERE customer_address LIKE "%TN%" [/SQL]