Name the least revenue for chelsea of england with rank less than 7
CREATE TABLE table_name_73 (revenue__ INTEGER, rank VARCHAR, country VARCHAR, team VARCHAR)
SELECT MIN(revenue__) AS $m_ FROM table_name_73 WHERE country = "england" AND team = "chelsea" AND rank < 7
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_73 (revenue__ INTEGER, rank VARCHAR, country VARCHAR, team VARCHAR) Question: Name the least revenue for chelsea of england with rank less than 7 [/INST] SELECT MIN(revenue__) AS $m_ FROM table_name_73 WHERE country = "england" AND team = "chelsea" AND rank < 7 </s>