What is the transfer window in esp with promoted type and more than 2010 ends?
CREATE TABLE "in" (
  "name" text,
  "country" text,
  "type" text,
  "moving_from" text,
  "transfer_window" text,
  "ends" real,
  "transfer_fee" text,
  "source" text
);
SELECT "transfer_window" FROM "in" WHERE "country"='esp' AND "type"='promoted' AND "ends">2010;