What is the average number of working horses of farms with more than 5000 total number of horses?
CREATE TABLE farm (Working_Horses INTEGER, Total_Horses INTEGER)
SELECT AVG(Working_Horses) FROM farm WHERE Total_Horses > 5000
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE farm (Working_Horses INTEGER, Total_Horses INTEGER) Question: What is the average number of working horses of farms with more than 5000 total number of horses? [/INST] SELECT AVG(Working_Horses) FROM farm WHERE Total_Horses > 5000 </s>