CREATE TABLE table_47596 ("Rank" CLOB, "Team" CLOB, "Run 1" CLOB, "Run 2" CLOB, "Run 3" CLOB, "Final" CLOB)

Which final has rank of 10?
SELECT "Final" FROM table_47596 WHERE "Rank" = '10'
SELECT "Final" FROM "table_47596" WHERE "Rank" = '10'