Table: cd_tenerife_uefa_cup
Columns: season
competition
round
club
home
away
aggregate

Question: Who was the away team in the semifinals?
SQL: SELECT "away" FROM cd_tenerife_uefa_cup WHERE "round" = 'semifinals'

Question: What is the home record for the Auxerre club?
SQL: SELECT "home" FROM cd_tenerife_uefa_cup WHERE "club" = 'auxerre'

Question: What is the home record for the Maccabi Tel-Aviv club?
SQL: SELECT "home" FROM cd_tenerife_uefa_cup WHERE "club" = 'maccabi tel-aviv'