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

Find the id and name of customers whose address contains WY state and do not use credit card for payment.
SELECT customer_id, customer_name FROM customers WHERE customer_address LIKE "%WY%" AND payment_method_code <> "Credit Card"
SELECT "customer_id", "customer_name" FROM "customers" WHERE "Credit Card" <> "payment_method_code" AND "customer_address" LIKE "%WY%"