1.【复习】找到所有有雇员的办公室(buildings)名字
SELECT DISTINCT Building FROM employees WHERE Building IS NOT NULL;
2.【复习】找到所有办公室里的所有角色(包含没有雇员的),并做唯一输出(DISTINCT)
SELECT DISTINCT Building_name,Role FROM Buildings LEFT JOIN employees ON Employees.Building=Buildings.Building_name;
3.【难题】找到所有有雇员的办公室(buildings)和对应的容量
SELECT DISTINCT Building,Capacity FROM Buildings LEFT JOIN employees ON Employees.Building=Buildings.Building_name WHERE Building IS NOT NULL;