user: ### NOW ANSWER:
Question: How many episodes had New York, New York as the location?
Columns: ['Episode Number', 'Location', 'Original Airdate', 'Challenge Winner', 'Challenge']
Types: ['real', 'text', 'text', 'text', 'text']
Sample row: [1.0, 'Amarillo, Texas', 'December 3, 2008', 'Man', '"Big Texan Challenge", a 4.5 pound (2kg) steak']
SQL:

assistant: SELECT COUNT("Episode Number") FROM "Table" WHERE "Location" = 'New York, New York';