CREATE TABLE table_203_868 (id NUMBER, "frequency band" CLOB, "band number" NUMBER, "radio interface" CLOB, "generation" CLOB, "status" CLOB, "notes" CLOB)

what are the number of times 4g is listed as the generation ?
SELECT COUNT(*) FROM table_203_868 WHERE "generation" = '4g'
SELECT COUNT(*) FROM "table_203_868" WHERE "generation" = '4g'