What were the new entries for the Semi-Finals round with fewer than 8 fixtures?
CREATE TABLE table_name_97 (new_entries_this_round VARCHAR, number_of_fixtures VARCHAR, round VARCHAR)
SELECT new_entries_this_round FROM table_name_97 WHERE number_of_fixtures < 8 AND round = "semi-finals"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_97 (new_entries_this_round VARCHAR, number_of_fixtures VARCHAR, round VARCHAR) Question: What were the new entries for the Semi-Finals round with fewer than 8 fixtures? [/INST] SELECT new_entries_this_round FROM table_name_97 WHERE number_of_fixtures < 8 AND round = "semi-finals" </s>