What is the sum of launches with Long March 3 and 0 failures?
CREATE TABLE table_name_4 (launches INTEGER, rocket VARCHAR, failures VARCHAR)
SELECT SUM(launches) FROM table_name_4 WHERE rocket = "long march 3" AND failures > 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_4 (launches INTEGER, rocket VARCHAR, failures VARCHAR) Question: What is the sum of launches with Long March 3 and 0 failures? [/INST] SELECT SUM(launches) FROM table_name_4 WHERE rocket = "long march 3" AND failures > 0 </s>