Table: soccer_game
Columns: tie_no
home_team
score_1
away_team
attendance

Question: What tie number featured Chelsea as the home team?
SQL: SELECT MIN("tie_no") FROM soccer_game WHERE "home_team" = 'Chelsea'

Question: In what tie were Leeds United the away team?
SQL: SELECT MAX("tie_no") FROM soccer_game WHERE "away_team" = 'Leeds United'

Question: Who was the home team when Burnley were the away team?
SQL: SELECT "home_team" FROM soccer_game WHERE "away_team" = 'Burnley'