Name the most wins total with wins indoor of 0 and wins outdoor of 1 with rank less than 7
CREATE TABLE table_name_68 (wins__total_ INTEGER, rank VARCHAR, wins__indoor_ VARCHAR, wins__outdoor_ VARCHAR)
SELECT MAX(wins__total_) FROM table_name_68 WHERE wins__indoor_ = 0 AND wins__outdoor_ = 1 AND rank < 7
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_68 (wins__total_ INTEGER, rank VARCHAR, wins__indoor_ VARCHAR, wins__outdoor_ VARCHAR) Question: Name the most wins total with wins indoor of 0 and wins outdoor of 1 with rank less than 7 [/INST] SELECT MAX(wins__total_) FROM table_name_68 WHERE wins__indoor_ = 0 AND wins__outdoor_ = 1 AND rank < 7 </s>