CREATE TABLE table_204_834 (id NUMBER, "rank" NUMBER, "name" CLOB, "nationality" CLOB, "time" CLOB)

who was the last finisher from the us ?
SELECT "name" FROM table_204_834 WHERE "nationality" = 'united states' ORDER BY "time" DESC LIMIT 1
SELECT "name" FROM "table_204_834" WHERE "nationality" = 'united states' ORDER BY "time" DESC FETCH FIRST 1 ROWS ONLY