What was the total viewership for BBC One weekly rankings larger than 7, before episode 4?
CREATE TABLE table_name_30 (total_viewers VARCHAR, bbc_one_weekly_ranking VARCHAR, episode_no VARCHAR)
SELECT total_viewers FROM table_name_30 WHERE bbc_one_weekly_ranking > 7 AND episode_no < 4
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_30 (total_viewers VARCHAR, bbc_one_weekly_ranking VARCHAR, episode_no VARCHAR) Question: What was the total viewership for BBC One weekly rankings larger than 7, before episode 4? [/INST] SELECT total_viewers FROM table_name_30 WHERE bbc_one_weekly_ranking > 7 AND episode_no < 4 </s>