CREATE TABLE table_204_340 (id NUMBER, "name" CLOB, "year inducted" NUMBER, "position" CLOB, "apps" NUMBER, "goals" NUMBER)

did the hall of fame player awarded the year after tony coton earn more goals than he did ?
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')
SELECT (SELECT "goals" FROM "table_204_340" WHERE "name" = 'tony coton') < (SELECT "goals" FROM "table_204_340" WHERE "year inducted" = (SELECT "year inducted" FROM "table_204_340" WHERE "name" = 'tony coton') + 1)