What year did the Capital City Giants have a game with the final score of 8-0?
CREATE TABLE table_name_54 (year INTEGER, team VARCHAR, score VARCHAR)
SELECT AVG(year) FROM table_name_54 WHERE team = "capital city giants" AND score = "8-0"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_54 (year INTEGER, team VARCHAR, score VARCHAR) Question: What year did the Capital City Giants have a game with the final score of 8-0? [/INST] SELECT AVG(year) FROM table_name_54 WHERE team = "capital city giants" AND score = "8-0" </s>