CREATE TABLE table_203_505 (id NUMBER, "number" NUMBER, "event" CLOB, "type" CLOB, "matthew" CLOB, "mark" CLOB, "luke" CLOB, "john" CLOB)

how many events does john describe ?
SELECT COUNT("event") FROM table_203_505 WHERE NOT "john" IS NULL
SELECT COUNT("event") FROM "table_203_505" WHERE NOT "john" IS NULL