CREATE TABLE farm (Farm_ID NUMBER, Year NUMBER, Total_Horses FLOAT, Working_Horses FLOAT, Total_Cattle FLOAT, Oxen FLOAT, Bulls FLOAT, Cows FLOAT, Pigs FLOAT, Sheep_and_Goats FLOAT)
CREATE TABLE farm_competition (Competition_ID NUMBER, Year NUMBER, Theme CLOB, Host_city_ID NUMBER, Hosts CLOB)
CREATE TABLE competition_record (Competition_ID NUMBER, Farm_ID NUMBER, Rank NUMBER)
CREATE TABLE city (City_ID NUMBER, Official_Name CLOB, Status CLOB, Area_km_2 FLOAT, Population FLOAT, Census_Ranking CLOB)

What are the statuses and average populations of each city Plot them as bar chart, and show in descending by the Y-axis.
SELECT Status, AVG(Population) FROM city GROUP BY Status ORDER BY AVG(Population) DESC
SELECT "Status", AVG("Population") FROM "city" GROUP BY "Status" ORDER BY AVG("Population") DESC