CREATE TABLE table_name_82 (rank NUMBER, studio VARCHAR2, director VARCHAR2)

What was the average rank for the film directed by roland emmerich under the studio of 20th century fox?
SELECT AVG(rank) FROM table_name_82 WHERE studio = "20th century fox" AND director = "roland emmerich"
SELECT AVG("rank") FROM "table_name_82" WHERE "20th century fox" = "studio" AND "director" = "roland emmerich"