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
### Context: 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? ### Answer: SELECT AVG(Working_Horses) FROM farm WHERE Total_Horses > 5000