-- Database schema
| buildings : id [ INT ] primary_key , name [ TEXT ] , City [ TEXT ] , Height [ INT ] , Stories [ INT ] , Status [ TEXT ] | Companies : id [ INT ] primary_key , name [ TEXT ] , Headquarters [ TEXT ] , Industry [ TEXT ] , Sales_billion [ INT ] , Profits_billion [ INT ] , Assets_billion [ INT ] , Market_Value_billion [ TEXT ] | Office_locations : building_id [ INT ] primary_key Office_locations.building_id = buildings.id , company_id [ INT ] Office_locations.company_id = Companies.id , move_in_year [ INT ] |
-- -- List the name of a building along with the name of a company whose office is in the building.

SELECT T3.name ,  T2.name FROM Office_locations AS T1 JOIN buildings AS T2 ON T1.building_id  =  T2.id JOIN Companies AS T3 ON T1.company_id  =  T3.id;