WHAT IS THE NUMBER OF VIEWERS WITH EPISODE LARGER THAN 10, RATING SMALLER THAN 2?
CREATE TABLE table_name_78 (viewers__millions_ INTEGER, episode_number VARCHAR, rating VARCHAR)
SELECT MAX(viewers__millions_) FROM table_name_78 WHERE episode_number > 10 AND rating < 2
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_78 (viewers__millions_ INTEGER, episode_number VARCHAR, rating VARCHAR) Question: WHAT IS THE NUMBER OF VIEWERS WITH EPISODE LARGER THAN 10, RATING SMALLER THAN 2? [/INST] SELECT MAX(viewers__millions_) FROM table_name_78 WHERE episode_number > 10 AND rating < 2 </s>