CREATE TABLE table_204_753 (id NUMBER, "no." NUMBER, "name" CLOB, "position" CLOB, "date of birth  ( age ) " CLOB, "signed from" CLOB, "notes" CLOB)

how many players were not signed from the academy ?
SELECT COUNT("name") FROM table_204_753 WHERE "signed from" <> 'the academy'
SELECT COUNT("name") FROM "table_204_753" WHERE "signed from" <> 'the academy'