What College/Junior/Club Team has Pick 50 before Round 8?
CREATE TABLE "nhl_amateur_draft" (
  "round" real,
  "pick" real,
  "player" text,
  "nationality" text,
  "college_junior_club_team" text
);
SELECT "college_junior_club_team" FROM "nhl_amateur_draft" WHERE "round"<8 AND "pick"=50;