What is the lowest weekly rank with an air date of november 26, 2007?
CREATE TABLE table_11178271_1 (weekly_rank INTEGER, air_date VARCHAR)
SELECT MIN(weekly_rank) FROM table_11178271_1 WHERE air_date = "November 26, 2007"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_11178271_1 (weekly_rank INTEGER, air_date VARCHAR) Question: What is the lowest weekly rank with an air date of november 26, 2007? [/INST] SELECT MIN(weekly_rank) FROM table_11178271_1 WHERE air_date = "November 26, 2007" </s>