SQL Lesson 7: 外连接（OUTER JOINs）

1.【复习】找到所有有雇员的办公室(buildings)名字

select distinct building
from employees
where building

2.【复习】找到所有办公室里的所有角色（包含没有雇员的）,并做唯一输出(DISTINCT)

SELECT distinct role,building_name from  buildings
left join employees
on employees.building = buildings.building_name

3.【难题】找到所有有雇员的办公室(buildings)和对应的容量

select distinct building,capacity
from employees
inner join buildings
 on employees.building=buildings.building_name