What is all the customer information for customers in NY state?
SELECT * FROM CUSTOMER WHERE State  =  "NY"
all the customer information refers to SELECT *; customers in NY state refers to WHERE State = 'NY';