How many episodes had New York, New York as the location?
CREATE TABLE table_24798489_1 (episode_number VARCHAR, location VARCHAR)
SELECT COUNT(episode_number) FROM table_24798489_1 WHERE location = "New York, New York"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_24798489_1 (episode_number VARCHAR, location VARCHAR) Question: How many episodes had New York, New York as the location? [/INST] SELECT COUNT(episode_number) FROM table_24798489_1 WHERE location = "New York, New York" </s>