user: Question: What was the total viewership for BBC One weekly rankings larger than 7, before episode 4?
Columns: ['Episode No.', 'Airdate', 'Total Viewers', 'Share', 'BBC One Weekly Ranking']
Types: ['real', 'text', 'real', 'text', 'real']
Sample row: [1.0, '8 April 2010', 6700000.0, '24.8%', 6.0]
SQL:

assistant: SELECT SUM("Total Viewers") FROM "Table" WHERE "BBC One Weekly Ranking" > 7.0 AND "Episode No." < 4.0;