what is the year when the position is 1/22 promoted and the leading scorer is james dean (27)?
CREATE TABLE table_name_81 (year VARCHAR, position VARCHAR, leading_scorer VARCHAR)
SELECT year FROM table_name_81 WHERE position = "1/22 promoted" AND leading_scorer = "james dean (27)"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_81 (year VARCHAR, position VARCHAR, leading_scorer VARCHAR) Question: what is the year when the position is 1/22 promoted and the leading scorer is james dean (27)? [/INST] SELECT year FROM table_name_81 WHERE position = "1/22 promoted" AND leading_scorer = "james dean (27)" </s>