CREATE TABLE table_name_90 (rank NUMBER, director VARCHAR2)

What is the average rank for the film directed by michael bay?
SELECT AVG(rank) FROM table_name_90 WHERE director = "michael bay"
SELECT AVG("rank") FROM "table_name_90" WHERE "director" = "michael bay"