Group by 和 correlated subqueries的转化

计算 emp 每个部门中每个岗位的最高薪水

参数：

		employee表，包含所有信息
		department 部门，string类型
		job 工作，string类型
    	salary 每个人的薪水，int类型

答案一：用group by

SELECT department,
       job,
       max(salary)
FROM employee
GROUP BY department,job

答案二：用correlated subqueries

SELECT department,
       job,
       salary
FROM employee a
WHERE salary = (SELECT max(salary)
				FROM employee b
				WHERE a.department = b.department and 
				      a.job = b.job
				)