#列出所有员工名字和其对应领导的名字
SELECT e.last_name 员工名字, m.last_name 领导名字
FROM
employees e
INNER JOIN
employees m
ON
e.`manager_id` = m.`employee_id`;
输出结果:
#对员工进行工资等级划分,并列出那些员工人数超过20个的工资等级
SELECT j.grade_level 工资等级,COUNT(*)人数
FROM employees e
INNER JOIN
jop_grades j
ON
e.`salary` BETWEEN j.`lowest_sal` AND j.`highest_sal`
GROUP BY
工资等级
HAVING
人数>10
ORDER BY 工资等级 DESC;
输出结果: