CREATE TABLE table_name_84 (rank INT, floors VARCHAR)

What is the average rank for a building with 24 floors?
SELECT AVG(rank) FROM table_name_84 WHERE floors = 24
SELECT AVG("rank") FROM "table_name_84" WHERE "floors" = 24