I want the average events for top 10 less than 4
CREATE TABLE table_name_17 (events INTEGER, top_10 INTEGER)
SELECT AVG(events) FROM table_name_17 WHERE top_10 < 4
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_17 (events INTEGER, top_10 INTEGER) Question: I want the average events for top 10 less than 4 [/INST] SELECT AVG(events) FROM table_name_17 WHERE top_10 < 4 </s>