What is the best top-5 when top-10 is 1 and there are more than 0 wins?
CREATE TABLE table_name_93 (top_5 INTEGER, top_10 VARCHAR, wins VARCHAR)
SELECT MAX(top_5) FROM table_name_93 WHERE top_10 = 1 AND wins > 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_93 (top_5 INTEGER, top_10 VARCHAR, wins VARCHAR) Question: What is the best top-5 when top-10 is 1 and there are more than 0 wins? [/INST] SELECT MAX(top_5) FROM table_name_93 WHERE top_10 = 1 AND wins > 0 </s>