1.【复习】找到雇员里还没有分配办公室的(列出名字和角色就可以)
SELECT name,role FROM employees where building is null ;
2.【难题】找到还没有雇员的办公室
SELECT building_name FROM buildings
where building_name not in
(select building from Employees where building is not null);
1.【复习】找到雇员里还没有分配办公室的(列出名字和角色就可以)
SELECT name,role FROM employees where building is null ;
2.【难题】找到还没有雇员的办公室
SELECT building_name FROM buildings
where building_name not in
(select building from Employees where building is not null);