What is the smallest Against with Lost larger than 0, % Won larger than 50, and Played smaller than 5?
CREATE TABLE table_name_48 (against INTEGER, played VARCHAR, lost VARCHAR, _percentage_won VARCHAR)
SELECT MIN(against) FROM table_name_48 WHERE lost > 0 AND _percentage_won > 50 AND played < 5
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_48 (against INTEGER, played VARCHAR, lost VARCHAR, _percentage_won VARCHAR) Question: What is the smallest Against with Lost larger than 0, % Won larger than 50, and Played smaller than 5? [/INST] SELECT MIN(against) FROM table_name_48 WHERE lost > 0 AND _percentage_won > 50 AND played < 5 </s>