SELECT Status ,  avg(Population) FROM city GROUP BY Status
What are the statuses and average populations of each city?
SELECT Status , avg ( Population ) FROM city GROUP BY Status
select status , avg ( population ) from city group by status
What are the statuses and average populations of each city ?