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)
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)

What's the mean result finding for product AP?
SELECT mean FROM resultsdata15 WHERE commod = "AP"
SELECT "mean" FROM "resultsdata15" WHERE "AP" = "commod"