CREATE TABLE table_2850912_8 (college_junior_club_team VARCHAR2, player VARCHAR2)

where did glenn greenough come from
SELECT college_junior_club_team FROM table_2850912_8 WHERE player = "Glenn Greenough"
SELECT "college_junior_club_team" FROM "table_2850912_8" WHERE "Glenn Greenough" = "player"