CREATE TABLE table_203_692 (id NUMBER, "name" CLOB, "pos." CLOB, "caps" NUMBER, "goals" NUMBER, "club" CLOB)

how many team players have less that 1 goal ?
SELECT COUNT("name") FROM table_203_692 WHERE "goals" < 1
SELECT COUNT("name") FROM "table_203_692" WHERE "goals" < 1