What is the nationality of the player from Round 2, Pick 19 from College of Kansas State?
CREATE TABLE table_name_42 (nationality VARCHAR, pick VARCHAR, round VARCHAR, college VARCHAR)
SELECT nationality FROM table_name_42 WHERE round = "2" AND college = "kansas state" AND pick = "19"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_42 (nationality VARCHAR, pick VARCHAR, round VARCHAR, college VARCHAR) Question: What is the nationality of the player from Round 2, Pick 19 from College of Kansas State? [/INST] SELECT nationality FROM table_name_42 WHERE round = "2" AND college = "kansas state" AND pick = "19" </s>