SELECT Status, AVG(Population) FROM city GROUP BY Status
Show the average of population from each status
CREATE TABLE competition_record (
    Competition_ID int,
    Farm_ID int,
    Rank int
)

CREATE TABLE farm (
    Farm_ID int,
    Year int,
    Total_Horses real,
    Working_Horses real,
    Total_Cattle real,
    Oxen real,
    Bulls real,
    Cows real,
    Pigs real,
    Sheep_and_Goats real
)

CREATE TABLE city (
    City_ID int,
    Official_Name text,
    Status text,
    Area_km_2 real,
    Population real,
    Census_Ranking text
)

CREATE TABLE farm_competition (
    Competition_ID int,
    Year int,
    Theme text,
    Host_city_ID int,
    Hosts text
)