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

Question: Which 2nd leg has pamesa valencia for team #2?
SQL: SELECT "2nd_leg" FROM uleb_knockout_2007_08 WHERE "team_2" = 'pamesa valencia'

Question: What is the team #1 that has unics kazan for team #2?
SQL: SELECT "team_1" FROM uleb_knockout_2007_08 WHERE "team_2" = 'unics kazan'

Question: What is the 1st leg that has akasvayu girona as team #2?
SQL: SELECT "1st_leg" FROM uleb_knockout_2007_08 WHERE "team_2" = 'akasvayu girona'