How many seasons have 1 goals and more than 11 apps?
CREATE TABLE "club_career_stats" (
  "season" real,
  "team" text,
  "country" text,
  "apps" real,
  "goals" real
);
SELECT COUNT("season") FROM "club_career_stats" WHERE "goals"=1 AND "apps">11;