综合练习打卡

题目：http://datawhale.club/t/topic/471
练习一: 各部门工资最高的员工（难度：中等）

SELECT 
	d.department_name, emplyee_name, max_salary
FROM
	employee
JOIN
	department d 
	ON employee.department_id = d.department_id
JOIN
	(SELECT department_id, MAX(salary) as max_salary
	 FROM employee
	 GROUP BY department_id) temp
	ON temp.department_id = d.department_id
WHERE 
	employee.salary = max_salary
ORDER BY
	max_salary DESC;