How many average total matches have league cup as the competition, with a draw greater than 0?
CREATE TABLE "most_derby_appearances" (
  "competition" text,
  "total_matches" real,
  "cardiff_win" real,
  "draw" real,
  "swansea_win" real
);
SELECT AVG("total_matches") FROM "most_derby_appearances" WHERE "competition"='league cup' AND "draw">0;