CREATE TABLE city (City_ID NUMBER, Official_Name CLOB, Status CLOB, Area_km_2 FLOAT, Population FLOAT, Census_Ranking CLOB)
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 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)

Show the number of competitions held in each city with a bar chart, and I want to list by the how many official name in asc.
SELECT Official_Name, COUNT(Official_Name) FROM city AS T1 JOIN farm_competition AS T2 ON T1.City_ID = T2.Host_city_ID GROUP BY Official_Name ORDER BY COUNT(Official_Name)
SELECT "Official_Name", COUNT("Official_Name") FROM "city" "T1" JOIN "farm_competition" "T2" ON "T1"."City_ID" = "T2"."Host_city_ID" GROUP BY "Official_Name" ORDER BY COUNT("Official_Name")