CREATE TABLE table_2781227_4 (college_junior_club_team VARCHAR2, nhl_team VARCHAR2)

For nhl team is san jose sharks mention all the college/junior/club team
SELECT college_junior_club_team FROM table_2781227_4 WHERE nhl_team = "San Jose Sharks"
SELECT "college_junior_club_team" FROM "table_2781227_4" WHERE "San Jose Sharks" = "nhl_team"