(1)查询各job_id的员工工资的最大值,最小值,平均值,总和。并按job_id排序
解析:【各“job_id”----->按“job_id”分组】【datediff:时间差几天】
SELECT MAX(salary), MIN(salary), AVG(salary), SUM(salary), job_id
FROM employees
GROUP BY job_id
ORDER BY job_id;
(2)查询员工最高工资和最低工资的差距(diffrence)
SELECT MAX(salary)-MIN(salary) diffrence
FROM employees;