What was the home team score at Richmond's away game against Footscray?
CREATE TABLE table_name_17 (home_team VARCHAR, away_team VARCHAR)
SELECT home_team AS score FROM table_name_17 WHERE away_team = "richmond"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_17 (home_team VARCHAR, away_team VARCHAR) Question: What was the home team score at Richmond's away game against Footscray? [/INST] SELECT home_team AS score FROM table_name_17 WHERE away_team = "richmond" </s>