Which Rank is the lowest one that has a Borough of richmondshire, and a Population larger than 8,178?
CREATE TABLE table_name_16 (rank INTEGER, borough VARCHAR, population VARCHAR)
SELECT MIN(rank) FROM table_name_16 WHERE borough = "richmondshire" AND population > 8 OFFSET 178 ROWS
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_16 (rank INTEGER, borough VARCHAR, population VARCHAR) Question: Which Rank is the lowest one that has a Borough of richmondshire, and a Population larger than 8,178? [/INST] SELECT MIN(rank) FROM table_name_16 WHERE borough = "richmondshire" AND population > 8 OFFSET 178 ROWS </s>