Which Home Team has a Road Team of rochester, and a Result of 71-78?
CREATE TABLE table_name_97 (home_team VARCHAR, road_team VARCHAR, result VARCHAR)
SELECT home_team FROM table_name_97 WHERE road_team = "rochester" AND result = "71-78"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_97 (home_team VARCHAR, road_team VARCHAR, result VARCHAR) Question: Which Home Team has a Road Team of rochester, and a Result of 71-78? [/INST] SELECT home_team FROM table_name_97 WHERE road_team = "rochester" AND result = "71-78" </s>