Schema: CREATE TABLE bank (bname VARCHAR, state VARCHAR)
Question: Find the branch names of banks in the New York state.
SQL: SELECT bname FROM bank WHERE state = 'New York'