For player is adam wiesel mention all the college/junior/club team 
CREATE TABLE table_2781227_4 (college_junior_club_team VARCHAR, player VARCHAR)
SELECT college_junior_club_team FROM table_2781227_4 WHERE player = "Adam Wiesel"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_2781227_4 (college_junior_club_team VARCHAR, player VARCHAR) Question: For player is adam wiesel mention all the college/junior/club team  [/INST] SELECT college_junior_club_team FROM table_2781227_4 WHERE player = "Adam Wiesel" </s>