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

Question: Which Team 2 had the 1st leg of 1–0?
SQL: SELECT "team_2" FROM african_cup_1995 WHERE "1st_leg" = '1–0'

Question: Which Team 1 had a 1st leg of 0–2?
SQL: SELECT "team_1" FROM african_cup_1995 WHERE "1st_leg" = '0–2'

Question: Which 2nd leg has a 1st leg of 2–0?
SQL: SELECT "2nd_leg" FROM african_cup_1995 WHERE "1st_leg" = '2–0'

Question: Goldfields Obuasi Team 1 has what Agg. totals ?
SQL: SELECT "agg" FROM african_cup_1995 WHERE "team_1" = 'goldfields obuasi'