How many game sites are there where the team record is 1–7?
CREATE TABLE table_25380472_2 (game_site VARCHAR, team_record VARCHAR)
SELECT COUNT(game_site) FROM table_25380472_2 WHERE team_record = "1–7"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_25380472_2 (game_site VARCHAR, team_record VARCHAR) Question: How many game sites are there where the team record is 1–7? [/INST] SELECT COUNT(game_site) FROM table_25380472_2 WHERE team_record = "1–7" </s>