Table schema:
CREATE TABLE park (state VARCHAR)

Question: How many parks are there in the state of NY?
SQL: SELECT COUNT(*) FROM park WHERE state = 'NY'