Table: ratings_weekly_2
Columns: week
sydney
melbourne
brisbane
adelaide
perth
total
nightly_rank

Question: What was the rating in Brisbane the week it was 276000 in Melbourne? 
SQL: SELECT MAX("brisbane") FROM ratings_weekly_2 WHERE "melbourne" = 276000

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

Question: What was the rating for Brisbane the week that Adelaide had 94000?
SQL: SELECT MIN("brisbane") FROM ratings_weekly_2 WHERE "adelaide" = 94000