CREATE TABLE table_203_573 (id NUMBER, "name" CLOB, "rank - 2000" NUMBER, "number" NUMBER, "country of origin" CLOB, "england - 2001" CLOB)

which name had a higher number ? smith or johnson ?
SELECT "name" FROM table_203_573 WHERE "name" IN ('smith', 'johnson') ORDER BY "number" DESC LIMIT 1
SELECT "name" FROM "table_203_573" WHERE "name" IN ('smith', 'johnson') ORDER BY "number" DESC FETCH FIRST 1 ROWS ONLY