Which player has no 0 results and multiples ties?
CREATE TABLE "list_of_ireland_cricket_captains" (
  "player" text,
  "dates_of_captaincy" text,
  "lost" real,
  "tied" real,
  "no_result" real,
  "pct_win_a" real
);
SELECT "player" FROM "list_of_ireland_cricket_captains" WHERE "no_result"=0 AND "tied">0;