Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
### Context:
CREATE TABLE table_24291077_8 (total VARCHAR, week VARCHAR)
### Question:
What was the total rating on week 3? 
### Answer:
SELECT total FROM table_24291077_8 WHERE week = 3