16.统计出当前各个title类型对应的员工当前薪水对应的平均工资
题目内容:
代码及思路:
题目漏了一个要求,是需要当前日期的,也就是to_date='9999-01-01'
SELECT titles.title,avg(salaries.salary) AS avg
FROM titles INNER JOIN salaries
ON titles.emp_no=salaries.emp_no
AND titles.to_date='9999-01-01'
AND salaries.to_date='9999-01-01'
GROUP BY titles.title;