Tell me the average final rank for loe more than 10 and point less than 43
CREATE TABLE table_name_8 (final_rank INTEGER, lose VARCHAR, point VARCHAR)
SELECT AVG(final_rank) FROM table_name_8 WHERE lose > 10 AND point < 43
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_8 (final_rank INTEGER, lose VARCHAR, point VARCHAR) Question: Tell me the average final rank for loe more than 10 and point less than 43 [/INST] SELECT AVG(final_rank) FROM table_name_8 WHERE lose > 10 AND point < 43 </s>