CREATE TABLE table_204_866 (id NUMBER, "name" CLOB, "lifetime" CLOB, "nationality" CLOB, "notable as" CLOB, "notes" CLOB)

mark ferrandino , frank ferri , joe fitzpatrick and ed flanagan were each what profession ?
SELECT "notable as" FROM table_204_866 WHERE "name" = 'mark ferrandino'
SELECT "notable as" FROM "table_204_866" WHERE "name" = 'mark ferrandino'