Learning Note
找到所有有雇员的办公室(buildings)名字:
SELECT DISTINCT building FROM Employees
LEFT JOIN Buildings
ON Employees.building = Buildings.building_name
WHERE Building
找到所有办公室里的所有角色(包含没有雇员的),并做唯一输出(DISTINCT):
SELECT DISTINCT Building_name, Role FROM Buildings
LEFT JOIN Employees
ON Employees.building = Buildings.building_name
找到所有有雇员的办公室(buildings)和对应的容量 ✓找到所有有雇员的办公室(buildings)和对应的容量 :
SELECT DISTINCT Building, Capacity FROM Employees
LEFT JOIN Buildings
ON Employees.building = Buildings.Building_name
LIMIT 2
找到雇员里还没有分配办公室的(列出名字和角色就可以) :
SELECT DISTINCT Name, Role FROM Employees
WHERE building is NULL
找到还没有雇员的办公室:
SELECT Buildings.building_name from Buildings
WHERE Buildings.building_name