Database: chinook_1
Question: Find all the customer information in state NY.
SQL:
SELECT * FROM CUSTOMER WHERE State  =  "NY"