Find the id of customers whose address contains WY state and do not use credit card for payment.
select customer_id from customers where customer_address like "%wy%" and payment_method_code ! = "Credit Card"
Can I have the customer's name please?
select customer_name from customers where customer_address like "%wy%" and payment_method_code ! = "Credit Card"
Please find the id and name of customers whose address contains WY state and use credit card for payment.
select customer_id, customer_name from customers where customer_address like "%wy%" and payment_method_code ! = "Credit Card"
Hmm. Can you please give me his email address and phone?
select customer_email, customer_phone from customers where customer_address like "%wy%" and payment_method_code ! = "Credit Card"