Championship larger than 3, and a FA Cup smaller than 3, and a Total smaller than 6 involves what highest league cup?
CREATE TABLE "top_scorers" (
  "name" text,
  "championship" real,
  "fa_cup" real,
  "league_cup" real,
  "total" real
);
SELECT MAX("league_cup") FROM "top_scorers" WHERE "championship">3 AND "fa_cup"<3 AND "total"<6;