SELECT name FROM buildings WHERE id NOT IN (SELECT building_id FROM Office_locations)
Which buildings do not have any company office? Give me the building names.
SELECT name FROM buildings WHERE id NOT IN ( SELECT building_id FROM Office_locations )
select name from buildings where id not in ( select building_id from office_locations )
Which buildings do not have any company office ? Give me the building names .