What is the total share for an episode with an air date of November 19, 2007?
CREATE TABLE table_name_2 (share INTEGER, air_date VARCHAR)
SELECT SUM(share) FROM table_name_2 WHERE air_date = "november 19, 2007"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_2 (share INTEGER, air_date VARCHAR) Question: What is the total share for an episode with an air date of November 19, 2007? [/INST] SELECT SUM(share) FROM table_name_2 WHERE air_date = "november 19, 2007" </s>