Show the names of all the buildings.
select name from building
Show the names of all buildings that have an institution.
select name from building where building_id in ( select building_id from institution )
Show the number of floors for each of the buildings that have an institution.
select floors from building where building_id in ( select building_id from institution )
Show the name of buildings that do not have an institution.
select name from building where building_id not in ( select building_id from institution )
What is the street address of the Bank of America Tower.
select street_address from building where name = "Bank of america Tower"
List the buildings that have an institution and their street address.
select name, street_address from building where building_id in ( select building_id from institution )