CREATE TABLE resultsdata15 (sample_pk NUMBER, commod CLOB, commtype CLOB, lab CLOB, pestcode CLOB, testclass CLOB, concen NUMBER, lod NUMBER, conunit CLOB, confmethod CLOB, confmethod2 CLOB, annotate CLOB, quantitate CLOB, mean CLOB, extract CLOB, determin CLOB)
CREATE TABLE sampledata15 (sample_pk NUMBER, state CLOB, year CLOB, month CLOB, day CLOB, site CLOB, commod CLOB, source_id CLOB, variety CLOB, origin CLOB, country CLOB, disttype CLOB, commtype CLOB, claim CLOB, quantity NUMBER, growst CLOB, packst CLOB, distst CLOB)

how many samples have unknown countries of origin?
SELECT COUNT(*) FROM sampledata15 WHERE origin = "3"
SELECT COUNT(*) FROM "sampledata15" WHERE "3" = "origin"