How many cardiff wins have a draw greater than 27?
CREATE TABLE "most_derby_appearances" (
  "competition" text,
  "total_matches" real,
  "cardiff_win" real,
  "draw" real,
  "swansea_win" real
);
SELECT COUNT("cardiff_win") FROM "most_derby_appearances" WHERE "draw">27;