Show the names of the buildings that have more than one company offices.
select 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 group by t1.building_id having count ( * ) > 1
The names of the companies that are present in that building.
select t3.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 where t2.name = "Torre KOI"
What other buildings is JPMorgan Chase also located in?
select 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 where t3.name = "JPMorgan Chase" and t2.name ! = "Torre KOI"
Does Torre Mitkah have an HSBC located in it?
select * 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 where t3.name = "HSBC" and t2.name = "Torre Mitikah"
What is the name of company with the company id 4?
select name from companies where id = 4
ExxonMobil is located in Punto Chapultepec, correct?
select * 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 where t3.name = "ExxonMobil" and t2.name = "Punto Chapultepec"
Which buildings have a General Electric then?
select 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 where t3.name = "General Electric"
What other companies are located in Corporativo BBVA Bancomer?
select t3.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 where t2.name = "Corporativo bbva Bancomer" and t3.name ! = "General Electric"