How many years was Kay Tagal Kang Hinintay directed by Rory Quintos and produced by Star Cinema?
CREATE TABLE table_name_94 (year VARCHAR, title VARCHAR, producer VARCHAR, director VARCHAR)
SELECT COUNT(year) FROM table_name_94 WHERE producer = "star cinema" AND director = "rory quintos" AND title = "kay tagal kang hinintay"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_94 (year VARCHAR, title VARCHAR, producer VARCHAR, director VARCHAR) Question: How many years was Kay Tagal Kang Hinintay directed by Rory Quintos and produced by Star Cinema? [/INST] SELECT COUNT(year) FROM table_name_94 WHERE producer = "star cinema" AND director = "rory quintos" AND title = "kay tagal kang hinintay" </s>