CREATE TABLE table_203_4 (id NUMBER, "medal" CLOB, "name" CLOB, "sport" CLOB, "event" CLOB, "date" CLOB)

what sport won the most gold medals ?
SELECT "sport" FROM table_203_4 WHERE "medal" = 'gold' GROUP BY "sport" ORDER BY COUNT(*) DESC LIMIT 1
SELECT "sport" FROM "table_203_4" WHERE "medal" = 'gold' GROUP BY "sport" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY