eg1
SELECT 列名 FROM 表1 INNER JOIN 表2 ON 连接条件;
select Employee.Name as Name
from (
select ManagerId as Id
from Employee
group by ManagerId
having count(Id) >= 5
) as Manager join Employee
on Manager.Id = Employee.Id
SELECT 列名 FROM 表1 INNER JOIN 表2 ON 连接条件;
select Employee.Name as Name
from (
select ManagerId as Id
from Employee
group by ManagerId
having count(Id) >= 5
) as Manager join Employee
on Manager.Id = Employee.Id