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"