Of all shows who have a rating larger than 7.8, aired on October 26, 2006, and has a share of over 14, what is the sum of the viewers?
CREATE TABLE table_name_91 (viewers INTEGER, share VARCHAR, rating VARCHAR, airdate VARCHAR)
SELECT SUM(viewers) FROM table_name_91 WHERE rating > 7.8 AND airdate = "october 26, 2006" AND share > 14
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_91 (viewers INTEGER, share VARCHAR, rating VARCHAR, airdate VARCHAR) Question: Of all shows who have a rating larger than 7.8, aired on October 26, 2006, and has a share of over 14, what is the sum of the viewers? [/INST] SELECT SUM(viewers) FROM table_name_91 WHERE rating > 7.8 AND airdate = "october 26, 2006" AND share > 14 </s>