Table: african_cup_football_2
Columns: team_1
agg
team_2
1st_leg
2nd_leg

Question: What team played against Al-Ismaily (team 1)?
SQL: SELECT "team_2" FROM african_cup_football_2 WHERE "team_1" = 'al-ismaily'

Question: What was the 2nd leg result in the match that scored a 2-0 in the 1st leg?
SQL: SELECT "2nd_leg" FROM african_cup_football_2 WHERE "1st_leg" = '2-0'

Question: When Kabwe Warriors (team 1) played, what was the result of the 1st leg?
SQL: SELECT "1st_leg" FROM african_cup_football_2 WHERE "team_1" = 'kabwe warriors'

Question: What team played against Hafia FC (team 2)?
SQL: SELECT "team_1" FROM african_cup_football_2 WHERE "team_2" = 'hafia fc'