CREATE TABLE table_204_691 (id NUMBER, "date" CLOB, "round" CLOB, "opponent" CLOB, "venue" CLOB, "result" CLOB, "attendance" NUMBER, "scorers" CLOB)

who scored more goals : mccoist or hateley ?
SELECT "scorers" FROM table_204_691 WHERE "scorers" IN ('mccoist', 'hateley') GROUP BY "scorers" ORDER BY COUNT(*) DESC LIMIT 1
SELECT "scorers" FROM "table_204_691" WHERE "scorers" IN ('mccoist', 'hateley') GROUP BY "scorers" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY