Table: swiss_cup_match
Columns: date
time
home
guest
result

Question: What was the result when home was fc luzern (asl)?
SQL: SELECT "result" FROM swiss_cup_match WHERE "home" = 'fc luzern (asl)'

Question: Who was the guest on 24.11.07 when the result was 0:1 at 16:00?
SQL: SELECT "guest" FROM swiss_cup_match WHERE "date" = '24.11.07' AND "result" = '0:1' AND "time" = '16:00'

Question: What day was the time 14:30, the result 0:1, and the home team fc chiasso (chl)?
SQL: SELECT "date" FROM swiss_cup_match WHERE "time" = '14:30' AND "result" = '0:1' AND "home" = 'fc chiasso (chl)'

Question: Who was the gues on 25.11.07 when home was stade nyonnais (1.l)?
SQL: SELECT "guest" FROM swiss_cup_match WHERE "date" = '25.11.07' AND "home" = 'stade nyonnais (1.l)'

Question: Who was the guest when the result was 0:3?
SQL: SELECT "guest" FROM swiss_cup_match WHERE "result" = '0:3'

Question: What was the result when the guest was fc zürich (asl)?
SQL: SELECT "result" FROM swiss_cup_match WHERE "guest" = 'fc zürich (asl)'