Who lost 2 and had a position bigger than 1?
CREATE TABLE "promotion_round" (
  "position" real,
  "name" text,
  "played" real,
  "drawn" real,
  "lost" real,
  "points" real
);
SELECT "name" FROM "promotion_round" WHERE "lost"=2 AND "position">1;