CREATE TABLE table_204_565 (id NUMBER, "game" NUMBER, "date" CLOB, "opponent" CLOB, "venue" CLOB, "result" CLOB, "attendance" NUMBER, "goalscorers" CLOB)

how many times did wright score after 1978 ?
SELECT COUNT(*) FROM table_204_565 WHERE "date" > 1978 AND "goalscorers" = 'wright'
SELECT COUNT(*) FROM "table_204_565" WHERE "date" > 1978 AND "goalscorers" = 'wright'