user: Question: Which Match played in a Location of San Francisco has a Competition of Semifinal?
Columns: ['Match', 'Date', 'Location', 'Lineup', 'Result', 'Competition']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ["Sweden 1995 FIFA Women's World Cup", "Sweden 1995 FIFA Women's World Cup", "Sweden 1995 FIFA Women's World Cup", "Sweden 1995 FIFA Women's World Cup", "Sweden 1995 FIFA Women's World Cup", "Sweden 1995 FIFA Women's World Cup"]
SQL:

assistant: SELECT "Match" FROM "Table" WHERE "Competition" = 'Semifinal' AND "Location" = 'San Francisco';