What year was 7th heaven made?
CREATE TABLE table_name_24 (year VARCHAR, film VARCHAR)
SELECT year FROM table_name_24 WHERE film = "7th heaven"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_24 (year VARCHAR, film VARCHAR) Question: What year was 7th heaven made? [/INST] SELECT year FROM table_name_24 WHERE film = "7th heaven" </s>