SCHEMA:
CREATE TABLE CUSTOMER (State VARCHAR)
USER:
Find all the customer information in state NY.

QUERY:
SELECT * FROM CUSTOMER WHERE State = "NY"