What is Date (Opening), when Year is less than 2010, and when Date (Closing) is "September 28"?
CREATE TABLE "history" (
  "year" real,
  "date_opening" text,
  "date_closing" text,
  "opening_film" text,
  "number_of_screening" text
);
SELECT "date_opening" FROM "history" WHERE "year"<2010 AND "date_closing"='september 28';