CREATE TABLE customers (customer_name VARCHAR2, customer_id VARCHAR2, customer_address VARCHAR2)

What are the names and ids of customers whose address contains TN?
SELECT customer_name, customer_id FROM customers WHERE customer_address LIKE "%TN%"
SELECT "customer_name", "customer_id" FROM "customers" WHERE "customer_address" LIKE "%TN%"