CREATE TABLE table_204_747 (id NUMBER, "season" CLOB, "skip" CLOB, "third" CLOB, "second" CLOB, "lead" CLOB, "events" CLOB)

who was second more , scott pfeifer or sean nedohin ?
SELECT "second" FROM table_204_747 WHERE "second" IN ('scott pfeifer', 'sean nedohin') GROUP BY "second" ORDER BY COUNT(*) DESC LIMIT 1
SELECT "second" FROM "table_204_747" WHERE "second" IN ('scott pfeifer', 'sean nedohin') GROUP BY "second" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY