CREATE TABLE CUSTOMER (State VARCHAR(255))
Find all the customer information in state NY.
    
SQL: SELECT * FROM CUSTOMER WHERE State = "NY"