Which team were runners-up in 2007 and had 1 under winners?
CREATE TABLE "performance_in_uefa_super_cup_by_club" (
  "team" text,
  "winners" real,
  "runners_up" real,
  "years_won" text,
  "years_runners_up" text
);
SELECT "team" FROM "performance_in_uefa_super_cup_by_club" WHERE "winners"=1 AND "years_runners_up"='2007';