CREATE TABLE table_204_461 (id NUMBER, "res." CLOB, "record" CLOB, "opponent" CLOB, "method" CLOB, "event" CLOB, "date" CLOB, "round" NUMBER, "time" CLOB, "location" CLOB, "notes" CLOB)

are there more wins by submission , or tko ?
SELECT "method" FROM table_204_461 WHERE "res." = 'win' AND "method" IN ('submission', 'tko') GROUP BY "method" ORDER BY COUNT(*) DESC LIMIT 1
SELECT "method" FROM "table_204_461" WHERE "method" IN ('submission', 'tko') AND "res." = 'win' GROUP BY "method" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY