When 4 mb is the sonnet what is the apple?
CREATE TABLE "table1_3002894_4" (
  "model" text,
  "sonnet" text,
  "apple" text,
  "n_upowr_117" text,
  "n_upowr_167" text,
  "n_upowr_183" text,
  "n_upowr_g3" text
);
SELECT "apple" FROM "table1_3002894_4" WHERE "sonnet"='4 MB';