CREATE TABLE table_204_521 (id NUMBER, "rank" NUMBER, "name" CLOB, "nationality" CLOB, "time  ( hand ) " CLOB, "notes" CLOB)

which competitor from united states had the longest time ?
SELECT "name" FROM table_204_521 WHERE "nationality" = 'united states' ORDER BY "time (hand)" DESC LIMIT 1
SELECT "name" FROM "table_204_521" WHERE "nationality" = 'united states' ORDER BY "time (hand)" DESC FETCH FIRST 1 ROWS ONLY