Which Scottish Cup has a League smaller than 561, Years of 1989–1995 1997–2001, and Europe smaller than 11?
CREATE TABLE "appearances" (
  "name" text,
  "years" text,
  "league" real,
  "scottish_cup" real,
  "league_cup" real,
  "europe" real,
  "total" real
);
SELECT COUNT("scottish_cup") FROM "appearances" WHERE "league"<561 AND "years"='1989–1995 1997–2001' AND "europe"<11;