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

how many people have more than 50 goals ?
SELECT COUNT("name") FROM table_204_340 WHERE "goals" > 50
SELECT COUNT("name") FROM "table_204_340" WHERE "goals" > 50