What was the average league with Kris Doolan and a total less than 5?
CREATE TABLE table_name_22 (league INTEGER, player VARCHAR, total VARCHAR)
SELECT AVG(league) FROM table_name_22 WHERE player = "kris doolan" AND total < 5
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_22 (league INTEGER, player VARCHAR, total VARCHAR) Question: What was the average league with Kris Doolan and a total less than 5? [/INST] SELECT AVG(league) FROM table_name_22 WHERE player = "kris doolan" AND total < 5 </s>