1.【复习】找到雇员里还没有分配办公室的(列出名字和角色就可以)
SELECT Name,Role FROM employees WHERE Building IS NULL;
2.【难题】找到还没有雇员的办公室
SELECT Building_name FROM Buildings LEFT JOIN Employees ON Employees.Building=Buildings.Building_name WHERE Role IS NULL;
SELECT Name,Role FROM employees WHERE Building IS NULL;
SELECT Building_name FROM Buildings LEFT JOIN Employees ON Employees.Building=Buildings.Building_name WHERE Role IS NULL;