What is the average number of million viewers that watched an episode before episode 11 with a share of 4?
CREATE TABLE table_name_28 (viewers__millions_ INTEGER, episode__number VARCHAR, share VARCHAR)
SELECT AVG(viewers__millions_) FROM table_name_28 WHERE episode__number < 11 AND share = "4"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_28 (viewers__millions_ INTEGER, episode__number VARCHAR, share VARCHAR) Question: What is the average number of million viewers that watched an episode before episode 11 with a share of 4? [/INST] SELECT AVG(viewers__millions_) FROM table_name_28 WHERE episode__number < 11 AND share = "4" </s>