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

Question: Which team lost 0-3 and 0-5?
SQL: SELECT "team_1" FROM african_cup_football WHERE "2nd_leg" = '0-3' AND "1st_leg" = '0-5'

Question: What was the 2nd leg score between Patronage Sainte-Anne and Asante Kotoko?
SQL: SELECT "2nd_leg" FROM african_cup_football WHERE "team_1" = 'asante kotoko'

Question: Which teams had an aggregate score of 3-4?
SQL: SELECT "team_1" FROM african_cup_football WHERE "agg" = '3-4'