CREATE TABLE record (ID INT, Result TEXT, Swimmer_ID INT, Event_ID INT)
CREATE TABLE stadium (ID INT, name TEXT, Capacity INT, City TEXT, Country TEXT, Opening_year INT)
CREATE TABLE swimmer (ID INT, name TEXT, Nationality TEXT, meter_100 FLOAT, meter_200 TEXT, meter_300 TEXT, meter_400 TEXT, meter_500 TEXT, meter_600 TEXT, meter_700 TEXT, Time TEXT)
CREATE TABLE event (ID INT, Name TEXT, Stadium_ID INT, Year TEXT)

A bar chart for finding the number of the names of stadiums that some Australian swimmers have been to, list from high to low by the names.
SELECT T4.Name, COUNT(T4.Name) FROM swimmer AS t1 JOIN record AS t2 ON t1.ID = t2.Swimmer_ID JOIN event AS t3 ON t2.Event_ID = t3.ID JOIN stadium AS t4 ON t4.ID = t3.Stadium_ID WHERE t1.Nationality = 'Australia' GROUP BY T4.Name ORDER BY T4.Name DESC
SELECT "T4"."Name", COUNT("T4"."Name") FROM "swimmer" AS "t1" JOIN "record" AS "t2" ON "t1"."ID" = "t2"."Swimmer_ID" JOIN "event" AS "t3" ON "t2"."Event_ID" = "t3"."ID" JOIN "stadium" AS "t4" ON "t3"."Stadium_ID" = "t4"."ID" WHERE "t1"."Nationality" = 'Australia' GROUP BY "T4"."Name" ORDER BY "T4"."Name" DESC NULLS LAST