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

Question: Who played as Team 2 against Team 1 SC Gagnoa?
SQL: SELECT "team_2" FROM african_cup_football_3 WHERE "team_1" = 'sc gagnoa'

Question: What was the 1st leg score when Mufulira Wanderers played as Team 2?
SQL: SELECT "1st_leg" FROM african_cup_football_3 WHERE "team_2" = 'mufulira wanderers'

Question: What's the score of the 1st leg when Water Corporation was Team 1?
SQL: SELECT "1st_leg" FROM african_cup_football_3 WHERE "team_1" = 'water corporation'

Question: What's the 1st leg score when Team 1 was Gor Mahia?
SQL: SELECT "1st_leg" FROM african_cup_football_3 WHERE "team_1" = 'gor mahia'

Question: Who played as Team 1 against Lomé i?
SQL: SELECT "team_1" FROM african_cup_football_3 WHERE "team_2" = 'lomé i'