Find all the customer information in state NY.
CREATE TABLE CUSTOMER (State VARCHAR)
SELECT * FROM CUSTOMER WHERE State = "NY"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE CUSTOMER (State VARCHAR) Question: Find all the customer information in state NY. [/INST] SELECT * FROM CUSTOMER WHERE State = "NY" </s>