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

Question: What is the first leg with an agg of 10-2?
SQL: SELECT "1st_leg" FROM african_cup_football_4 WHERE "agg" = '10-2'

Question: What is the agg of team 2 for Vantour Club Mangoungou?
SQL: SELECT "agg" FROM african_cup_football_4 WHERE "team_2" = 'vantour club mangoungou'

Question: What is the first leg of team 1 for Hardware stars?
SQL: SELECT "1st_leg" FROM african_cup_football_4 WHERE "team_1" = 'hardware stars'

Question: What is the agg with a second leg of 0-1?
SQL: SELECT "agg" FROM african_cup_football_4 WHERE "2nd_leg" = '0-1'

Question: What team 2 had a 1st leg of 1-1, and agg of 3-1?
SQL: SELECT "team_2" FROM african_cup_football_4 WHERE "1st_leg" = '1-1' AND "agg" = '3-1'

Question: What team 2 had a second leg of 3-2?
SQL: SELECT "team_2" FROM african_cup_football_4 WHERE "2nd_leg" = '3-2'