Database: department_store
Question: What are the ids and names of customers with addressed that contain WY and who do not use a credit card for payment?
SQL:
SELECT customer_id ,  customer_name FROM customers WHERE customer_address LIKE "%WY%" AND payment_method_code != "Credit Card"