Database: farm
Question: What are the statuses and average populations of each city?
SQL:
SELECT Status ,  avg(Population) FROM city GROUP BY Status