Which club has 1 runners-up with 0 winners and 2 third place earned?
CREATE TABLE "winners_by_team" (
  "rank" real,
  "club" text,
  "winners" real,
  "runners_up" real,
  "third" real
);
SELECT "club" FROM "winners_by_team" WHERE "runners_up"=1 AND "winners"=0 AND "third"=2;