CREATE TABLE table_203_535 (id NUMBER, "rank" NUMBER, "nation" CLOB, "gold" NUMBER, "silver" NUMBER, "bronze" NUMBER, "total" NUMBER)

did the united states win above 10 medals ?
SELECT (SELECT "total" FROM table_203_535 WHERE "nation" = 'united states') > 10
SELECT (SELECT "total" FROM "table_203_535" WHERE "nation" = 'united states') > 10