CREATE TABLE Locations (Location_ID VARCHAR2, Address VARCHAR2)
CREATE TABLE Tourist_Attractions (Name VARCHAR2, Location_ID VARCHAR2, How_to_Get_There VARCHAR2)

What are the names of tourist attractions that can be reached by bus or is at address 254 Ottilie Junction?
SELECT T2.Name FROM Locations AS T1 JOIN Tourist_Attractions AS T2 ON T1.Location_ID = T2.Location_ID WHERE T1.Address = "254 Ottilie Junction" OR T2.How_to_Get_There = "bus"
SELECT "T2"."Name" FROM "Locations" "T1" JOIN "Tourist_Attractions" "T2" ON ("254 Ottilie Junction" = "T1"."Address" OR "T2"."How_to_Get_There" = "bus") AND "T1"."Location_ID" = "T2"."Location_ID"