Database: department_store
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%"