what is the average tie no when the home team is stamford a.f.c.?
CREATE TABLE table_name_11 (tie_no INTEGER, home_team VARCHAR)
SELECT AVG(tie_no) FROM table_name_11 WHERE home_team = "stamford a.f.c."
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_11 (tie_no INTEGER, home_team VARCHAR) Question: what is the average tie no when the home team is stamford a.f.c.? [/INST] SELECT AVG(tie_no) FROM table_name_11 WHERE home_team = "stamford a.f.c." </s>