How may college/junior/club team has a the nhl team listed as Colorado Avalanche?
CREATE TABLE "round_five" (
  "pick" text,
  "player" text,
  "position" text,
  "nationality" text,
  "nhl_team" text,
  "college_junior_club_team" text
);
SELECT COUNT("college_junior_club_team") FROM "round_five" WHERE "nhl_team"='Colorado Avalanche';