CREATE TABLE table_name_31 (rank NUMBER, headquarters VARCHAR2, market_value__billion_$_ VARCHAR2)

What is the average rank for USA when the market value is 407.2 billion?
SELECT AVG(rank) FROM table_name_31 WHERE headquarters = "usa" AND market_value__billion_$_ > 407.2
SELECT AVG("rank") FROM "table_name_31" WHERE "headquarters" = "usa" AND "market_value__billion_$_" > 407.2