Changes

ELSE 0::int END AS undisclosedflag

FROM firmbase;

SELECT COUNT(*) FROM firmbase1 WHERE undisclosedflag = 0;