1.查询各job_id的员工工资的最大值,最小值,平均值,总和并按照job_id升序 SELECT MAX(salary),MIN(salary),AVG(salary),SUM(salary),job_id FROM employees GROUP BY job_id