SQL :查询平均工资最低的部门信息

2、查询平均工资最低的部门信息
#法一：
##①查询每个部门的平均工资

	SELECT AVG(salary) ag, department_id
	FROM employees 
	GROUP BY department_id

##②查询①中的最低工资

	SELECT MIN(ag)
	FROM(SELECT AVG(salary) ag, department_id
			FROM employees 
			GROUP BY department_id) ag_d

##③哪个部门平均工资=③的部门

	SELECT department_id  
	FROM employees  
	GROUP BY department_id 
	HAVING AVG(salary) = (SELECT MIN(ag)
						  FROM(SELECT AVG(salary) ag, department_id
						  	   FROM employees 
							   GROUP BY department_id
							   ) ag_d 
						  )

##④部门编号为③的部门的信息

	SELECT *
	FROM departments 
	WHERE department_id = (SELECT department_id  
						   FROM employees  
						   GROUP BY department_id 
						   HAVING AVG(salary) = (SELECT MIN(ag)
												 FROM(SELECT AVG(salary) ag, department_id
													  FROM employees 
													  GROUP BY department_id
													  ) ag_d