How many seasons have Losses larger than 1, and a Competition of fiba europe cup, and Wins smaller than 4?
CREATE TABLE "european_campaigns" (
  "season" real,
  "competition" text,
  "games" real,
  "wins" real,
  "loses" real,
  "against" text
);
SELECT COUNT("season") FROM "european_campaigns" WHERE "loses">1 AND "competition"='fiba europe cup' AND "wins"<4;