CREATE TABLE swimmer (id NUMBER, name CLOB, nationality CLOB, meter_100 NUMBER, meter_200 CLOB, meter_300 CLOB, meter_400 CLOB, meter_500 CLOB, meter_600 CLOB, meter_700 CLOB, time CLOB)
CREATE TABLE record (id NUMBER, result CLOB, swimmer_id NUMBER, event_id NUMBER)
CREATE TABLE event (id NUMBER, name CLOB, stadium_id NUMBER, year CLOB)
CREATE TABLE stadium (id NUMBER, name CLOB, capacity NUMBER, city CLOB, country CLOB, opening_year NUMBER)

Find the names of stadiums that some Australian swimmers have been to.
SELECT 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'
SELECT "t4"."name" FROM "swimmer" "t1" JOIN "record" "t2" ON "t1"."id" = "t2"."swimmer_id" JOIN "event" "t3" ON "t2"."event_id" = "t3"."id" JOIN "stadium" "t4" ON "t3"."stadium_id" = "t4"."id" WHERE "t1"."nationality" = 'Australia'