user: Question: What was the total rating on week 3? 
Columns: ['WEEK', 'Sydney', 'Melbourne', 'Brisbane', 'Adelaide', 'Perth', 'TOTAL', 'NIGHTLY RANK']
Types: ['real', 'real', 'real', 'real', 'real', 'real', 'real', 'real']
Sample row: [1.0, 336000.0, 276000.0, 128000.0, 110000.0, 118000.0, 969000.0, 5.0]
SQL:

assistant: SELECT "TOTAL" FROM "Table" WHERE "WEEK" = 3.0;