What is the fewest number of wins that had fewer than 7 draws and more than 30 played?
CREATE TABLE table_name_26 (wins INTEGER, draws VARCHAR, played VARCHAR)
SELECT MIN(wins) FROM table_name_26 WHERE draws < 7 AND played > 30
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_26 (wins INTEGER, draws VARCHAR, played VARCHAR) Question: What is the fewest number of wins that had fewer than 7 draws and more than 30 played? [/INST] SELECT MIN(wins) FROM table_name_26 WHERE draws < 7 AND played > 30 </s>