Which player has a Position of defence, and a Pick # of 6?
CREATE TABLE table_name_42 (player VARCHAR, position VARCHAR, pick__number VARCHAR)
SELECT player FROM table_name_42 WHERE position = "defence" AND pick__number = "6"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_42 (player VARCHAR, position VARCHAR, pick__number VARCHAR) Question: Which player has a Position of defence, and a Pick # of 6? [/INST] SELECT player FROM table_name_42 WHERE position = "defence" AND pick__number = "6" </s>