Task: Text to Code
Input (English): Return the names and ids of customers who have TN in their address.
Output (English): SELECT customer_name ,  customer_id FROM customers WHERE customer_address LIKE "%TN%"