What is the greatest successes that have failures greater than 1 and launches less than 28?
CREATE TABLE table_name_25 (successes INTEGER, failures VARCHAR, launches VARCHAR)
SELECT MAX(successes) FROM table_name_25 WHERE failures > 1 AND launches < 28
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_25 (successes INTEGER, failures VARCHAR, launches VARCHAR) Question: What is the greatest successes that have failures greater than 1 and launches less than 28? [/INST] SELECT MAX(successes) FROM table_name_25 WHERE failures > 1 AND launches < 28 </s>