——查询部门工资均大于3000的部门及部门最低工资,以工资升序排列
select min(salary) 最低工资,department_id 部门编号 from employees group by department_id having min(salary) > 3000 order by 最低工资;
——查询部门工资均大于3000的部门及部门最低工资,以工资升序排列
select min(salary) 最低工资,department_id 部门编号 from employees group by department_id having min(salary) > 3000 order by 最低工资;