Win % larger than 47.1, and a Matches smaller than 145 had what lowest lost?
CREATE TABLE table_name_47 (lost INTEGER, win__percentage VARCHAR, matches VARCHAR)
SELECT MIN(lost) FROM table_name_47 WHERE win__percentage > 47.1 AND matches < 145
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (lost INTEGER, win__percentage VARCHAR, matches VARCHAR) Question: Win % larger than 47.1, and a Matches smaller than 145 had what lowest lost? [/INST] SELECT MIN(lost) FROM table_name_47 WHERE win__percentage > 47.1 AND matches < 145 </s>