human
Schema:
architect (id, name, nationality, gender)
bridge (architect_id, id, name, location, length_meters, length_feet)
mill (architect_id, id, location, name, type, built_year, notes)
Please answer with SQL.
assistant
Sure, I understand.
human
List the locations of all bridges.
assistant
SELECT DISTINCT LOCATION FROM bridge;
human
Where is the bridge named Kolob Arch located?
assistant
SELECT LOCATION FROM bridge WHERE name = 'Kolob Arch';
human
Include the location of the bridge named Rainbow Bridge .
assistant
SELECT LOCATION FROM bridge WHERE name = "Kolob Arch" OR name = "Rainbow Bridge" ;