What are the id and name of each customer?
select customer_id, customer_name from customers
Only return those for customers whose address contains WY.
select customer_id, customer_name from customers where customer_address like "%wy%"
Find the ids and names of customers whose address contains WY state and do not use credit cards for payment.
select customer_id, customer_name from customers where customer_address like "%wy%" and payment_method_code != "Credit Card"