Which Year has a Producer of viva films, and a Title of magkapatid?
CREATE TABLE table_name_41 (year VARCHAR, producer VARCHAR, title VARCHAR)
SELECT year FROM table_name_41 WHERE producer = "viva films" AND title = "magkapatid"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_41 (year VARCHAR, producer VARCHAR, title VARCHAR) Question: Which Year has a Producer of viva films, and a Title of magkapatid? [/INST] SELECT year FROM table_name_41 WHERE producer = "viva films" AND title = "magkapatid" </s>