Which Semifinal has an Event of team?
CREATE TABLE table_name_47 (semifinal VARCHAR, event VARCHAR)
SELECT semifinal FROM table_name_47 WHERE event = "team"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (semifinal VARCHAR, event VARCHAR) Question: Which Semifinal has an Event of team? [/INST] SELECT semifinal FROM table_name_47 WHERE event = "team" </s>