CREATE TABLE people (People_ID NUMBER, Name CLOB, Age FLOAT, Height FLOAT, Hometown CLOB)
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)

What are the hometowns of gymnasts and the corresponding number of gymnasts, and order x axis in desc order.
SELECT Hometown, COUNT(*) FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID = T2.People_ID GROUP BY T2.Hometown ORDER BY Hometown DESC
SELECT "Hometown", COUNT(*) FROM "gymnast" "T1" JOIN "people" "T2" ON "T1"."Gymnast_ID" = "T2"."People_ID" GROUP BY "T2"."Hometown" ORDER BY "Hometown" DESC