CREATE TABLE swimmer (id VARCHAR2, nationality VARCHAR2)
CREATE TABLE record (swimmer_id VARCHAR2, event_id VARCHAR2)
CREATE TABLE event (id VARCHAR2, stadium_id VARCHAR2)
CREATE TABLE stadium (name VARCHAR2, id VARCHAR2)

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'