What is the lowest value for Sydney, when WEEKLY RANK is less than 8, and when Brisbane is greater than 252,000?
CREATE TABLE table_name_16 (sydney INTEGER, weekly_rank VARCHAR, brisbane VARCHAR)
SELECT MIN(sydney) FROM table_name_16 WHERE weekly_rank < 8 AND brisbane > 252 OFFSET 000 ROWS
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_16 (sydney INTEGER, weekly_rank VARCHAR, brisbane VARCHAR) Question: What is the lowest value for Sydney, when WEEKLY RANK is less than 8, and when Brisbane is greater than 252,000? [/INST] SELECT MIN(sydney) FROM table_name_16 WHERE weekly_rank < 8 AND brisbane > 252 OFFSET 000 ROWS </s>