Failures larger than 0, and a Successes of 1 has what lowest partial failures?
CREATE TABLE table_name_64 (partial_failures INTEGER, failures VARCHAR, successes VARCHAR)
SELECT MIN(partial_failures) FROM table_name_64 WHERE failures > 0 AND successes = 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_64 (partial_failures INTEGER, failures VARCHAR, successes VARCHAR) Question: Failures larger than 0, and a Successes of 1 has what lowest partial failures? [/INST] SELECT MIN(partial_failures) FROM table_name_64 WHERE failures > 0 AND successes = 1 </s>