SQLite: Find NOT NULL empty records

-- find NOT NULL empty records

SELECT COUNT(*) FROM big_list WHERE pubchem_cid IS NULL OR trim(pubchem_cid) ="";

"How are you gonna keep ‘em down on the farm once they’ve seen Karl Hungus?"