I want to know the team that was sacked and date of vacancy was 4 december
CREATE TABLE table_name_68 (team VARCHAR, manner_of_departure VARCHAR, date_of_vacancy VARCHAR)
SELECT team FROM table_name_68 WHERE manner_of_departure = "sacked" AND date_of_vacancy = "4 december"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_68 (team VARCHAR, manner_of_departure VARCHAR, date_of_vacancy VARCHAR) Question: I want to know the team that was sacked and date of vacancy was 4 december [/INST] SELECT team FROM table_name_68 WHERE manner_of_departure = "sacked" AND date_of_vacancy = "4 december" </s>