did the hall of fame player awarded the year after tony coton earn more goals than he did ?
CREATE TABLE table_204_340 (
    id number,
    "name" text,
    "year inducted" number,
    "position" text,
    "apps" number,
    "goals" number
)
SELECT (SELECT "goals" FROM table_204_340 WHERE "year inducted" = (SELECT "year inducted" FROM table_204_340 WHERE "name" = 'tony coton') + 1) > (SELECT "goals" FROM table_204_340 WHERE "name" = 'tony coton')
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: did the hall of fame player awarded the year after tony coton earn more goals than he did ? ### Input: CREATE TABLE table_204_340 (
    id number,
    "name" text,
    "year inducted" number,
    "position" text,
    "apps" number,
    "goals" number
) ### Response: SELECT (SELECT "goals" FROM table_204_340 WHERE "year inducted" = (SELECT "year inducted" FROM table_204_340 WHERE "name" = 'tony coton') + 1) > (SELECT "goals" FROM table_204_340 WHERE "name" = 'tony coton')