Table: football_league_trophy_2
Columns: tie_no
home_team
score
away_team
attendance

Question: What is listed as the Tie no for Home team of Gillingham?
SQL: SELECT "tie_no" FROM football_league_trophy_2 WHERE "home_team" = 'gillingham'

Question: What is the Tie no listed for the Away team of Barnet?
SQL: SELECT "tie_no" FROM football_league_trophy_2 WHERE "away_team" = 'barnet'

Question: What is listed for the Attendance that has a Tie no of 5?
SQL: SELECT "attendance" FROM football_league_trophy_2 WHERE "tie_no" = '5'

Question: Which Away team has a Tie no of 4?
SQL: SELECT "away_team" FROM football_league_trophy_2 WHERE "tie_no" = '4'

Question: Which Home Team has an Attendance of 1,859?
SQL: SELECT "home_team" FROM football_league_trophy_2 WHERE "attendance" = '1,859'

Question: What is listed as the Away team for the Home team of the Bristol Rovers?
SQL: SELECT "away_team" FROM football_league_trophy_2 WHERE "home_team" = 'bristol rovers'