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

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" AS "T1" JOIN "Tourist_Attractions" AS "T2" ON ("254 Ottilie Junction" = "T1"."Address" OR "T2"."How_to_Get_There" = "bus") AND "T1"."Location_ID" = "T2"."Location_ID"