What is the pick number for position of D from the University of Maine (NCAA)?
CREATE TABLE table_name_50 (pick__number VARCHAR, position VARCHAR, college_junior_club_team VARCHAR)
SELECT pick__number FROM table_name_50 WHERE position = "d" AND college_junior_club_team = "university of maine (ncaa)"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_50 (pick__number VARCHAR, position VARCHAR, college_junior_club_team VARCHAR) Question: What is the pick number for position of D from the University of Maine (NCAA)? [/INST] SELECT pick__number FROM table_name_50 WHERE position = "d" AND college_junior_club_team = "university of maine (ncaa)" </s>