CREATE TABLE table_name_74 (gross VARCHAR, studio VARCHAR, director_s_ VARCHAR)

The 20th Century Fox film directed by Joel Schumacher grossed how much?
SELECT gross FROM table_name_74 WHERE studio = "20th century fox" AND director_s_ = "joel schumacher"
SELECT "gross" FROM "table_name_74" WHERE "20th century fox" = "studio" AND "director_s_" = "joel schumacher"