user: ### NOW ANSWER:
Question: what is the average tie no when the home team is Stamford A.F.C.?
Columns: ['Tie no', 'Home team', 'Score', 'Away team', 'Attendance']
Types: ['real', 'text', 'text', 'text', 'real']
Sample row: [1.0, 'Liversedge', '0–3', 'Kendal Town', 198.0]
SQL:

assistant: SELECT AVG("Tie no") FROM "Table" WHERE "Home team" = 'Stamford A.F.C.';