Which Label-Nr has a Year smaller than 1968, and a Label of world pacific, and an album of chile con soul?
CREATE TABLE "singles_as" (
  "year" real,
  "title" text,
  "from_album" text,
  "label" text,
  "label_nr" text
);
SELECT "label_nr" FROM "singles_as" WHERE "year"<1968 AND "label"='world pacific' AND "from_album"='chile con soul';