Database: department_store
Question: Find the id and name of customers whose address contains WY state and do not use credit card for payment.
SQL:
SELECT customer_id ,  customer_name FROM customers WHERE customer_address LIKE "%WY%" AND payment_method_code != "Credit Card"