Schema: CREATE TABLE table_name_82 (rank INTEGER, studio VARCHAR, director VARCHAR)
Question: What was the average rank for the film directed by roland emmerich under the studio of 20th century fox?
SQL: SELECT AVG(rank) FROM table_name_82 WHERE studio = "20th century fox" AND director = "roland emmerich"