SELECT customer_id, customer_name FROM customers WHERE customer_address LIKE "%WY%" AND payment_method_code <> "Credit Card"
Temukan ID dan nama pelanggan yang alamatnya berisi WY State dan jangan gunakan kartu kredit untuk pembayaran.
CREATE TABLE customers (customer_id VARCHAR, customer_name VARCHAR, customer_address VARCHAR, payment_method_code VARCHAR)