human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: WEEK, Sydney, Melbourne, Brisbane, Adelaide, Perth, TOTAL, NIGHTLY RANK
###Question: What was the rating for Brisbane the week that Adelaide had 94000?
gpt
SELECT MIN Brisbane FROM table WHERE Adelaide = 94000