Table schema:
CREATE TABLE table_24291077_8 (total VARCHAR, week VARCHAR)

Question: What was the total rating on week 3? 
SQL: SELECT total FROM table_24291077_8 WHERE week = 3