Who was the artist before 2010 with a Promotional 7" as a format?
CREATE TABLE "releases" (
  "year" real,
  "artist" text,
  "title" text,
  "format" text,
  "type" text
);
SELECT "artist" FROM "releases" WHERE "year"<2010 AND "format"='promotional 7\"';