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