Que equipa de escola/clube tem a escolha 50 antes da 8a ronda?
CREATE TABLE table_name_19 (college_junior_club_team VARCHAR, round VARCHAR, pick VARCHAR)
SELECT college_junior_club_team FROM table_name_19 WHERE round < 8 AND pick = 50