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)

Which varieties of apple typically have higher pesticide levels?
SELECT T1.variety FROM resultsdata15 AS T2 JOIN sampledata15 AS T1 ON T1.sample_pk = T2.sample_pk WHERE T2.commod = "AP" GROUP BY T1.variety ORDER BY SUM(T2.concen) DESC LIMIT 1
SELECT "T1"."variety" FROM "resultsdata15" "T2" JOIN "sampledata15" "T1" ON "T1"."sample_pk" = "T2"."sample_pk" WHERE "AP" = "T2"."commod" GROUP BY "T1"."variety" ORDER BY SUM("T2"."concen") DESC FETCH FIRST 1 ROWS ONLY