Table: tiffeny_milbrett_match_stats
Columns: match
date
location
lineup
result
competition

Question: On What Date is the Competition Semifinal that has a result of 2-1 aet?
SQL: SELECT "date" FROM tiffeny_milbrett_match_stats WHERE "competition" = 'semifinal' AND "result" = '2-1 aet'

Question: Which Location has a Competition of Group Stage, a Lineup of Start and a Date of 2000-09-17?
SQL: SELECT "location" FROM tiffeny_milbrett_match_stats WHERE "competition" = 'group stage' AND "lineup" = 'start' AND "date" = '2000-09-17'

Question: Which Match has a Competition of Group Stage on 2000-09-17?
SQL: SELECT "match" FROM tiffeny_milbrett_match_stats WHERE "competition" = 'group stage' AND "date" = '2000-09-17'

Question: Which Match played in a Location of San Francisco has a Competition of Semifinal?
SQL: SELECT "match" FROM tiffeny_milbrett_match_stats WHERE "competition" = 'semifinal' AND "location" = 'san francisco'

Question: What Location has a Date of 1995-06-15?
SQL: SELECT "location" FROM tiffeny_milbrett_match_stats WHERE "date" = '1995-06-15'