案例: 查询每个部门每个工种的员工的平均工资,并且按平均工资的高低排列 排序查询放在最后
SELECT AVG(salary) a, department_id, job_id
FROM employees
WHERE department_id IS NOT NULL
GROUP BY department_id, job_id
HAVING a>10000
ORDER BY a DESC;
案例: 查询每个部门每个工种的员工的平均工资,并且按平均工资的高低排列 排序查询放在最后
SELECT AVG(salary) a, department_id, job_id
FROM employees
WHERE department_id IS NOT NULL
GROUP BY department_id, job_id
HAVING a>10000
ORDER BY a DESC;