SELECT customer_id ,  customer_name FROM customers WHERE customer_address LIKE "%WY%" AND payment_method_code != "Credit Card"
What are the ids and names of customers with addressed that contain WY and who do not use a 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 customer_address like value and payment_method_code ! = value
What are the ids and names of customers with addressed that contain WY and who do not use a credit card for payment ?