For MySQL:

Write a query to display customer name for all customers who are from the state of Arizona, New York & Washington. Use only the list operator. Use the EX schema.

Here is what I have

SELECT CONCAT(customer_last_name, ', ', customer_first_name) AS full_name, CONCAT(customer_state) AS State FROM ex.customers WHERE customer_state IN ('NY', 'WA', 'AZ') ORDER BY customer_last_name;

It is only giving me names for WA, but not New York or Arizona.