What is the highest Round, when Draft is greater than 1980, and when Player is "Shane Doan Category:Articles with hCards"?
CREATE TABLE table_name_46 (round INTEGER, draft VARCHAR, player VARCHAR)
SELECT MAX(round) FROM table_name_46 WHERE draft > 1980 AND player = "shane doan category:articles with hcards"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_46 (round INTEGER, draft VARCHAR, player VARCHAR) Question: What is the highest Round, when Draft is greater than 1980, and when Player is "Shane Doan Category:Articles with hCards"? [/INST] SELECT MAX(round) FROM table_name_46 WHERE draft > 1980 AND player = "shane doan category:articles with hcards" </s>