Tell me the average Rank for lossess less than 6 and wins less than 11 for michigan state
CREATE TABLE table_name_30 (rank INTEGER, school VARCHAR, losses VARCHAR, wins VARCHAR)
SELECT AVG(rank) FROM table_name_30 WHERE losses < 6 AND wins < 11 AND school = "michigan state"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_30 (rank INTEGER, school VARCHAR, losses VARCHAR, wins VARCHAR) Question: Tell me the average Rank for lossess less than 6 and wins less than 11 for michigan state [/INST] SELECT AVG(rank) FROM table_name_30 WHERE losses < 6 AND wins < 11 AND school = "michigan state" </s>