CREATE TABLE table_32003 ("Rank" FLOAT, "Nation" TEXT, "Gold" FLOAT, "Silver" FLOAT, "Bronze" FLOAT, "Total" FLOAT)

What is the rank of the Nation that has fewer than 24 total medals are more than 7 Gold medals?
SELECT AVG("Rank") FROM table_32003 WHERE "Total" < '24' AND "Gold" > '7'
SELECT AVG("Rank") FROM "table_32003" WHERE "Gold" > '7' AND "Total" < '24'