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

Question: What was the score in the 1st leg when Stade d'Abidjan was Team 2?
SQL: SELECT "1st_leg" FROM african_cup_football WHERE "team_2" = 'stade d''abidjan'

Question: What was the aggregate score that had Union Douala as Team 1?
SQL: SELECT "agg" FROM african_cup_football WHERE "team_1" = 'union douala'

Question: What was the 2nd leg score of the aggregate score of 4-9?
SQL: SELECT "2nd_leg" FROM african_cup_football WHERE "agg" = '4-9'

Question: Who was Team 2 when Stationery Stores was Team 1?
SQL: SELECT "team_2" FROM african_cup_football WHERE "team_1" = 'stationery stores'

Question: Which Team 1 has an aggregate score of 1-1 1?
SQL: SELECT "team_1" FROM african_cup_football WHERE "agg" = '1-1 1'