CREATE TABLE table_48107 ("Rank" FLOAT, "Title" CLOB, "Studio" CLOB, "Director" CLOB, "Worldwide Gross" CLOB)

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