Database: department_store
Question: Return the names and ids of customers who have TN in their address.
SQL:
SELECT customer_name ,  customer_id FROM customers WHERE customer_address LIKE "%TN%"