CREATE TABLE table_204_878 (id NUMBER, "model" CLOB, "release date" CLOB, "sensor\ res. ,  size" CLOB, "lens  ( 35 mm equiv. ) \ zoom ,  aperture" CLOB, "screen\ size ,  pixels" CLOB, "dimensions\ w  ( mm )  \\u00d7 h  ( mm )  \\u00d7 d  ( mm ) " CLOB, "weight" CLOB, "features" CLOB)

how many were released in 2012 ?
SELECT COUNT(*) FROM table_204_878 WHERE "release date" = 2012
SELECT COUNT(*) FROM "table_204_878" WHERE "release date" = 2012