Table: cup_tie_results
Columns: tie_no
home_team
score
away_team
date

Question: What was the highest Tie no when the home team was the Bolton Wanderers, and the date was Middlesbrough?
SQL: SELECT MAX("tie_no") FROM cup_tie_results WHERE "home_team" = 'bolton wanderers' AND "date" = 'middlesbrough'

Question: What is the average Tie no when the date is Birmingham City?
SQL: SELECT AVG("tie_no") FROM cup_tie_results WHERE "date" = 'birmingham city'

Question: What was the Tie no when then home team was Stoke City for the game played on 9 February 1946?
SQL: SELECT "tie_no" FROM cup_tie_results WHERE "home_team" = 'stoke city' AND "date" = '9 february 1946'