Which rank has a total less than 9, less than 2 bronze, and from France?
CREATE TABLE table_name_26 (rank VARCHAR, nation VARCHAR, total VARCHAR, bronze VARCHAR)
SELECT rank FROM table_name_26 WHERE total < 9 AND bronze < 2 AND nation = "france"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_26 (rank VARCHAR, nation VARCHAR, total VARCHAR, bronze VARCHAR) Question: Which rank has a total less than 9, less than 2 bronze, and from France? [/INST] SELECT rank FROM table_name_26 WHERE total < 9 AND bronze < 2 AND nation = "france" </s>