CREATE TABLE table_204_75 (id NUMBER, "year" NUMBER, "place" CLOB, "gold" CLOB, "silver" CLOB, "bronze" CLOB)

which country has won more gold medals : china or mexico ?
SELECT "gold" FROM table_204_75 WHERE "gold" IN ('chn', 'mex') GROUP BY "gold" ORDER BY COUNT(*) DESC LIMIT 1
SELECT "gold" FROM "table_204_75" WHERE "gold" IN ('chn', 'mex') GROUP BY "gold" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY