who scored more goals : mccoist or hateley ?
CREATE TABLE table_204_691 (
    id number,
    "date" text,
    "round" text,
    "opponent" text,
    "venue" text,
    "result" text,
    "attendance" number,
    "scorers" text
)
SELECT "scorers" FROM table_204_691 WHERE "scorers" IN ('mccoist', 'hateley') GROUP BY "scorers" ORDER BY COUNT(*) DESC LIMIT 1
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: who scored more goals : mccoist or hateley ? ### Input: CREATE TABLE table_204_691 (
    id number,
    "date" text,
    "round" text,
    "opponent" text,
    "venue" text,
    "result" text,
    "attendance" number,
    "scorers" text
) ### Response: SELECT "scorers" FROM table_204_691 WHERE "scorers" IN ('mccoist', 'hateley') GROUP BY "scorers" ORDER BY COUNT(*) DESC LIMIT 1