CREATE TABLE gymnast (Gymnast_ID NUMBER, Floor_Exercise_Points FLOAT, Pommel_Horse_Points FLOAT, Rings_Points FLOAT, Vault_Points FLOAT, Parallel_Bars_Points FLOAT, Horizontal_Bar_Points FLOAT, Total_Points FLOAT)
CREATE TABLE people (People_ID NUMBER, Name CLOB, Age FLOAT, Height FLOAT, Hometown CLOB)

How many gymnasts are from each hometown Plot them as bar chart, rank in asc by the total number please.
SELECT Hometown, COUNT(*) FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID = T2.People_ID GROUP BY T2.Hometown ORDER BY COUNT(*)
SELECT "Hometown", COUNT(*) FROM "gymnast" "T1" JOIN "people" "T2" ON "T1"."Gymnast_ID" = "T2"."People_ID" GROUP BY "T2"."Hometown" ORDER BY COUNT(*)