Who is the player who has a total less than 4, no scottish cups, and a league cup greater than 0?
CREATE TABLE "top_scorers" (
  "player" text,
  "position" text,
  "league_cup" real,
  "scottish_cup" real,
  "uefa_champions_league" real,
  "total" real
);
SELECT "player" FROM "top_scorers" WHERE "total"<4 AND "scottish_cup"=0 AND "league_cup">0;