CREATE TABLE table_name_40 (rank NUMBER, year VARCHAR2)

In 1950 what is the average rank?
SELECT AVG(rank) FROM table_name_40 WHERE year = 1950
SELECT AVG("rank") FROM "table_name_40" WHERE "year" = 1950