The 20th Century Fox film directed by Joel Schumacher grossed how much?
CREATE TABLE table_name_74 (gross VARCHAR, studio VARCHAR, director_s_ VARCHAR)
SELECT gross FROM table_name_74 WHERE studio = "20th century fox" AND director_s_ = "joel schumacher"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_74 (gross VARCHAR, studio VARCHAR, director_s_ VARCHAR) Question: The 20th Century Fox film directed by Joel Schumacher grossed how much? [/INST] SELECT gross FROM table_name_74 WHERE studio = "20th century fox" AND director_s_ = "joel schumacher" </s>