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

Question: Which team 1 had a team 2 of Asante Kotoko?
SQL: SELECT "team_1" FROM african_cup_football_3 WHERE "team_2" = 'asante kotoko'

Question: Which team 1 had a team 2 of Hafia FC?
SQL: SELECT "team_1" FROM african_cup_football_3 WHERE "team_2" = 'hafia fc'

Question: What was the aggregate for the match with a team 2 of Hafia FC?
SQL: SELECT "agg" FROM african_cup_football_3 WHERE "team_2" = 'hafia fc'

Question: Who was the team 1 that had a 1st leg score of 0-1?
SQL: SELECT "team_1" FROM african_cup_football_3 WHERE "1st_leg" = '0-1'

Question: Which team 2 had an aggregate score of 3-4 and a 2nd leg score of 0-2?
SQL: SELECT "team_2" FROM african_cup_football_3 WHERE "agg" = '3-4' AND "2nd_leg" = '0-2'