What school or team has round of 2 with less than 42 picks?
CREATE TABLE table_name_50 (school_club_team VARCHAR, round VARCHAR, pick VARCHAR)
SELECT school_club_team FROM table_name_50 WHERE round = 2 AND pick < 42
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_50 (school_club_team VARCHAR, round VARCHAR, pick VARCHAR) Question: What school or team has round of 2 with less than 42 picks? [/INST] SELECT school_club_team FROM table_name_50 WHERE round = 2 AND pick < 42 </s>