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

number of teams above 9 medals
SELECT COUNT("nation") FROM table_203_466 WHERE "total" > 9
SELECT COUNT("nation") FROM "table_203_466" WHERE "total" > 9