#
#案例 查询每个部门的员工个数
SELECT d.department_id,
(
SELECT COUNT(*)
FROM employees e
WHERE e.department_id=d.`department_id`
) 个数
FROM departments d;
# 案例 查询员工号=102的部门名
SELECT department_name,employee_id
FROM departments d
JOIN employees e
ON e.`department_id`=d.`department_id`
WHERE employee_id=102;
SELECT (
SELECT department_name
FROM departments d
INNER JOIN employees e
ON e.`department_id`=d.`department_id`
WHERE e.employee_id=102
) 部门名;
# select 后的子查询仅仅支持标量子查询,不支持多行子查询
from 后
#from后面子查询
#from后面跟的是 表,所以 from后面的子查询结果当做一个表
# 案例: 查询每个部门的平均工资的工资等级
SELECT AVG(salary),department_id
FROM employees
GROUP BY department_id;
SELECT j.`grade_level`,ag.*
FRO